oracle datatype blob array how to use in

2 posts, 0 answers
  1. NA
    NA avatar
    39 posts
    Member since:
    Aug 2013

    Posted 18 Jan 2014 Link to this post

    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.....
  2. David
    David avatar
    121 posts
    Member since:
    Jan 2011

    Posted 18 Jan 2014 Link to this post

    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.
Back to Top