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."
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.