Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Executing PL/SQL with button press.

446956Jul 11 2008 — edited Jul 15 2008
Hi-
What i'm attempting to do is simple. I have a single HTML page with a region on it called "Buttons" and a single button. The point of the button when pressed is to execute an Oracle stored procedure which performs a query and inserts the result set into a temporary table. Under "Database Manipulation Request/Database Action", i've selected "No Database Action". Under Conditions, i've select Condition Type of "PL/SQL Expression" and placed the name of the procedure in the Expression 1 box. When i run the page, i get the following error:

Invalid PL/SQL expression condition: ORA-06550: line 1, column 34: PLS-00222: no function with name 'PRC_LOAD_TEMP_BULK_DATA' exists in this scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored

The executable is a "procedure" not a function, and i'm guessing that i haven't set up the button properly. How do i properly initiate a database executable from the press of a button?
thanx,
jim.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Jul 11 2008
8 comments
1,837 views