This content has been marked as final. Show 7 replies
You call PROCEDURES & FUNCTIONS inside the package, not the package itself.. Example:
Package SamplePackage has a procedure called y and a function called z, to call procedure y you do this: Execute SamplePackage.y(Parameters, Go, Here);
to call a function you would do this:
(q is a declared local variable of type varchar2(100))
q := SamplePackage.z(Parameters,Go,Here);
"I am a Ranger. We walk in the dark places no others will enter. We stand on the bridge and no one may pass. We live for the One, we die for the One."
Thank Tony Miller,
I have to use page process or anything else.
I create a region and apex made sql statements. I convert the SQL to PLSQL store procedure as a procedure in package.
I want to call it. Please let me know step by step how to call it.
You can convert the existing page P/SQL process like this
select into ...
update table set ...
pkg_name.pkg_procedure( v1, v2,v3 OUT);
:P1_PROCESS_RESULT := V3;
so "pkg_name.pkg_procedure" is taking care all process
Hope this clarifies.
When I create a form, I am able to choose from procedure.
I want to select the option when I build a form.
I would like to know how to call from APEX the procedure is in DB.
Do you mean you want a drop down list of the procedures in the package to select from?
I imagine that if that is the case and you had the right authorization, you could use a query from the DBA_* (or ALL or USER) views to get a list and build a dynamic call that way. Haven't tried it though.
Edited by: ARGGH99 on Dec 28, 2012 11:59 AM
Please refrain from posting to a LONG SINCE DEAD thread..