How To Call A DB Procedure From Oracle Forms ?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How To Call A DB Procedure From Oracle Forms ?

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    How To Call A DB Procedure From Oracle Forms ?

    I need help calling a database procedure from an Oracle Form 6i. I need to pass a value to x_old_ccc and execute the procedure from a form. This is the test procedure I had created:

    CREATE OR REPLACE PROCEDURE ccc_test (x_old_ccc IN VARCHAR2)
    AS
    v_rowid ROWID;
    BEGIN
    UPDATE ron_ccc_tbl
    SET test_ccc = 'ABCD'
    WHERE old_ccc = x_old_ccc;
    COMMIT;
    END;

    Thaks, Ron

  2. #2
    Join Date
    Mar 2011
    Posts
    1
    Inside Forms U plz write oracle <user name>(in which the form is connected).<proc_name>

Similar Threads

  1. syntax to call procedure inside a procedure in db2
    By anshulsarabhai in forum Database
    Replies: 1
    Last Post: 07-08-2005, 02:08 PM
  2. Replies: 1
    Last Post: 04-23-2003, 09:47 AM
  3. Oracle Developer 2000 - Forms
    By W. Roper in forum Database
    Replies: 1
    Last Post: 12-12-2001, 01:02 AM
  4. Oracle Stored Procedure for trimming table
    By Saiful in forum Database
    Replies: 1
    Last Post: 05-02-2001, 06:35 AM
  5. Replies: 0
    Last Post: 06-14-2000, 02:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center