Re: SQL Plus and stored procs

"Dim" <species_at_hem2.passagen.se> wrote in message news:8uon7s$32d2_at_pen6.pen.k12.va.us...
> Why can't I execute package procedures via SQL Plus?
>
> there's a package in Oracle Portal 3 called PORTAL30_SSO.WWSSO_LS_PRIVATE
> which contains a procedure LS_CHANGE_PASSWORD. I have tried many ways
> to get it to run via SQL Plus, but I never got it right.
> Here's how I try to call it:
>
> DECLARE
> outvar1 NUMBER;
> BEGIN
> PORTAL30_SSO.WWSSO_LS_PRIVATE.LS_CHANGE_PASSWORD
> (P_SSOUSER => 'domino',
> P_OLDPWD => 'ergoforce5',
> P_NEWPWD => 'devil888',
> PO_ERR => outvar1);
> END;
> /
>
>
> Definition for the proc :
>
> /**
> * SSO user change password
> *
> * This procedure is used to change user sso password
> * To avoid user frustration, the form presented to user should make
> * the user enter the new pwd twice and use javascript to validate
> equality.
> *
> * <template>
> * wwsso_ls_private.ls_change_password
> * (
> * p_ssouser ==> -- IN varchar2
> * ,p_newpwd ==> -- IN VARCHAR2
> * ,po_err ==> -- OUT NUMBER
> * );
> * </template>
> *
> * <code>
> * wwsso_ls_private.ls_change_password(
> * p_ssouser ==> sso user name
> * ,p_newpwd ==> new password
> * , po_err ==> error code
> * );
> * </code>
> *
> * _at_param p_ssouser The sso user name, used to delete from list
> * _at_param p_newpwd The new password
> * _at_param po_err Error code
> * _at_exception user_not_found;
> *
> */
> PROCEDURE ls_change_password
> (
> p_ssouser IN VARCHAR2,
> p_oldpwd IN VARCHAR2,
> p_newpwd IN VARCHAR2,
> po_err OUT NUMBER
> );
>
> What am i doing wrong?
> Is there any other way to call a procedure?
> The final idea is to execute the procedure from an Java application.
>
> Thanks in advance.
> Dmitriy

Do you have the permissions to execute it? Why can't you execute it (are you getting an error or something)?

-Matt Received on Mon Nov 13 2000 - 16:07:39 CET