This is a migrated thread and some comments may be shown as answers.

oracle datatype blob array how to use in Asp.net?

1 Answer 83 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
NA
Top achievements
Rank 1
NA asked on 18 Jan 2014, 02:11 PM
ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [], [], [], [], []

ORA-06544: PL/SQL: internal error, arguments: [78502], [], [], [], [], [], [], []

ORA-06553: PLS-801: internal error [78502] 
pls help me.....

1 Answer, 1 is accepted

Sort by
0
David
Top achievements
Rank 1
Iron
Veteran
Iron
answered on 18 Jan 2014, 04:56 PM
You have not given us remotely enough information to be able to help you. 

The error message suggests that you have passed invalid values to a PL/SQL procedure.  As i do not have access to the statement you used to access the feature, nor any of the associated documentation, I have to be a bit vague.

In my experience with Oracle it all boils down to having parameters defined with the correct values.  Do not forget to set the directions for the parameters when dealing with stored procedures (which you appear to be using).  Oracle allows for results, input, and input/output values.  Also be aware that some oracle versons support named parameters whereas others support positional parameters.  A positional parameter normally is represented by a "?" symbol in your SQL statements.

Now as to being a BLOB you have to worry about which type of blobs.  Oracle supports multiple types of blobs.  Your parameters much type and size of the parameters being passed.
Tags
General Discussions
Asked by
NA
Top achievements
Rank 1
Answers by
David
Top achievements
Rank 1
Iron
Veteran
Iron
Share this question
or