Re: ERROR ORA-65553 PLS-306

gstoch_at_gmail.com wrote:
> 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.

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org