My Oracle Support Banner

Packaged Procedure From VBScript Using ODBC Connection Fail With Error Ora--06550 (Doc ID 359133.1)

Last updated on JUNE 21, 2019

Applies to:

Oracle ODBC Driver - Version 9.2.0.3 to 10.2.0.4.8
z*OBSOLETE: Microsoft Windows
MS Windows
Microsoft Windows


Symptoms

Cannot call packaged procedure in VBScript when connected using Oracle ODBC driver by a user other than the packaged procedure owner. That user has all the priviliges to the procedure. The packaged procedure can be called in SQL Plus. It also can be called in VBScript with the same Oracle ODBC driver using the packaged procedure owner.

[Oracle][ODBC][Ora]ORA-06550: line 1, column 13: PLS-00302: component
'MY_PKG' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement
ignored
/oralmasp/testMetalink.asp, line 22

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.