Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Plus and stored procs

Re: SQL Plus and stored procs

From: Glenn Goslin <glenng_at_iafrica.com>
Date: Thu, 16 Nov 2000 21:13:12 +0200
Message-ID: <3a1432cd.0@news1.mweb.co.za>

I have had the same error. The length of a string which was being placed into a varchar2 variable, exceeded the size of the declared variable. Either trim the string, or increase the size of the variable.

Hope that helps.

Glenn
Dim <species_at_hem2.passagen.se> wrote in message news:8up1e2$im62_at_pen6.pen.k12.va.us...
> Yepp I'm getting an error.
> I connect to database as a owner of the package, so I dont think there's a
> question of privilegies.
> There's two types of error I get:
>
> ORA-06510 PL/SQL: unhandled user-defined exception str
> and
> ORA-06502 PL/SQL: numeric or value error
>
> Sometimes I get one, sometimes another. there seems to be no special cause
> :-(
>
>
>
>
> "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>
> > *
> > * @param p_ssouser The sso user name, used to delete from list
> > * @param p_newpwd The new password
> > * @param po_err Error code
> > * @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 Thu Nov 16 2000 - 13:13:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US