SQL Plus and stored procs
From: Dim <species_at_hem2.passagen.se>
Date: Mon, 13 Nov 2000 13:36:47 +0100
Message-ID: <8uon7s$32d2_at_pen6.pen.k12.va.us>
Date: Mon, 13 Nov 2000 13:36:47 +0100
Message-ID: <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
Received on Mon Nov 13 2000 - 13:36:47 CET