Home » SQL & PL/SQL » SQL & PL/SQL » ora-06553
ora-06553 [message #19557] Wed, 27 March 2002 13:32 Go to next message
Lynn
Messages: 5
Registered: March 2002
Junior Member
I had a store procedure written in oracle 8.16, called from VB.It works fine in Windows environment.
The Client use Oracle 8.16 in Unix, also called from
VB.
get the Error Message:
[[Microsoft]][[ODBC Driver for Oracle]][[Oracle]]ORA-06553:PLS-:

I don't what cause the problem, paramter type, or something else.
( the standard message should be
ORA-06553 PLS-string: string
)
Any help to solve this issue will be greatly appreciated.

thanks.

Lynn
xlzeng@yahoo.com
416-643-7459
Re: ora-06553 [message #19578 is a reply to message #19557] Thu, 28 March 2002 21:32 Go to previous messageGo to next message
Somu
Messages: 24
Registered: February 2000
Junior Member
Hi,

You need to install the Oracle ODBC Driver in the client Machine.
Re: ora-06553 [message #19582 is a reply to message #19557] Fri, 29 March 2002 06:28 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
The Microsoft Oracle ODBC driver is not installed. Download Microsoft Data Access Components (MDAC) and install it. I would suggest not using Microsoft's Oracle ODBC driver. Instead install the Oracle ODBC client software from Oracle. Microsoft's version doesn't support all data types. Oracle's is much more stable and supports all data type and will automatically recognize primary keys and use the associated indexes.
Previous Topic: Truncate and COALESCE
Next Topic: urgent plz guide me!
Goto Forum:
  


Current Time: Fri Apr 19 05:51:38 CDT 2024