Hi

FUNCTION
gst.ala(al_id_up => :al_id_up,
as_p => :as_p,
as_s => :as_s);

al_id_up IN
as_p OUT
as_s OUT

How i can use this function in sql ?
When i try use this function

Select gst.ala(1234);

i have massage error ORA-65553 PLS-306

please help me.

On 20 nov, 10:20, gst... (AT) gmail (DOT) com wrote:
Go learn SQL & PL/SQL! You didn't even read the basics!

Cheers.

Carlos.

gstoch (AT) gmail (DOT) com wrote:
What you have described, above, is not a function. Run the following
and post the results.

set long 1000000

SELECT dbms_metadata.get_ddl('FUNCTION', "GST.ALA") FROM dual;

Also post the actual error message not your abbreviated interpretation
of it and your version number.

PS: Whoever named the object and its parameters needs a basic class in
programming.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org