Toad World® Forums

ORA-01036

With the latest version of the beta(12.10.0.12), I am getting an Ora-01036 every time I compile a package body. I’ve tried with a couple of packages including one that is just a function that returns nothing. The package compile seems to be successful.

Spool SQL to screen and post the offending query, thanks.

Here is the output for the test package body.


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.100

CREATE OR REPLACE PACKAGE BODY APPS.test AS

/******************************************************************************

NAME: test

PURPOSE:

REVISIONS:

Ver Date Author Description


1.0 7/26/2016 jcummings 1. Created this package body.

******************************************************************************/

FUNCTION MyFunction(Param1 IN NUMBER) RETURN NUMBER IS

BEGIN

RETURN Param1;

END;

PROCEDURE MyProcedure(Param1 IN NUMBER) IS

TmpVar NUMBER;

BEGIN

TmpVar := Param1;

END;

END test;


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.160

Select line, position, SUBSTR (text, 1, 200) text

FROM SYS.user_errors

WHERE name = :oname AND TYPE = :otype

ORDER BY sequence;

:oname(VARCHAR[4],IN/OUT)=‘TEST’

:otype(VARCHAR[12],IN/OUT)=‘PACKAGE BODY’


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.180

Select object_type, object_id

FROM sys.user_objects

WHERE object_name = :name

AND object_type = ‘PACKAGE’;

:name(VARCHAR[4],IN/OUT)=‘TEST’


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.190

Select argument_name,

     -- char_length /* 10g+ */,

     -- char_used /* 10g+ */,

     character_set_name,

     data_length,

     data_level,

     data_precision,

     data_scale,

     data_type,

     -- default_length,

     -- default_value,

     defaulted /* 11g+ */,

     in_out,

     object_id,

     object_name,

     overload,

     user AS owner,

     package_name,

     pls_type,

     position,

     radix,

     sequence,

     -- subprogram_id, /* 10.2+ */

     type_link,

     type_name,

     type_owner,

     type_subname

FROM sys.user_arguments

WHERE object_id = :obj_id

ORDER BY object_name, overload, sequence;

:obj_id(INTEGER,IN)=3875141


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.200

:obj_id(INTEGER,IN/OUT)=3875141


– Session: APPS@DEV.BWES.NET

– Timestamp: 13:00:19.200

Error: ORA-01036: illegal variable name/number

From: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]

Sent: Tuesday, July 26, 2016 12:38 PM

To: toadoraclebeta@toadworld.com

Subject: EXTERNAL: RE: [Toad for Oracle - Beta Discussion Forum] ORA-01036

RE: ORA-01036

Reply by Michael Staszewski

Spool SQL to screen and post the offending query, thanks.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


----------------------------------------- This message is intended only for the individual or entity to which it is addressed and contains information that is proprietary to The Babcock & Wilcox Company and/or its affiliates, or may be otherwise confidential. If the reader of this message is not the intended recipient, or the employee agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return e-mail and delete this message from your computer. Thank you.

Hmm, I’m not sure. I created sample package in a few schemas including APPS and all went as expected. Can you zip and send me your user files offline? michaelstaszewskiquest.com. Also send me your Support Bundle.

Thanks,

Michael

Thanks, this is fixed in next beta.