SQL Plus and stored procs

[Quoted] [Quoted] Why can't I execute package procedures via SQL Plus?

there's a package in Oracle Portal 3 called PORTAL30_SSO.WWSSO_LS_PRIVATE [Quoted] [Quoted] which contains a procedure LS_CHANGE_PASSWORD. I have tried many ways [Quoted] 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 [Quoted]
• the user enter the new pwd twice and use javascript to validate equality.
  *
  
• <template> [Quoted]
• 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 [Quoted]
• _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 Received on Mon Nov 13 2000 - 13:36:47 CET