3 Replies Latest reply on Sep 13, 2006 6:13 PM by gdarling - oracle

    Error ORA-06502 PL/SQL

    468701
      Hi, i have this error when i try to call a store procedure from my VB.NET (2005) program.

      The store procedure:
      CREATE OR REPLACE PROCEDURE MY_EXECUTE (CMD IN VARCHAR2, FIELD IN VARCHAR2, IID OUT NUMBER) IS
      BEGIN
      EXECUTE IMMEDIATE CMD || ' RETURNING ' || FIELD || ' INTO :1' USING OUT IID;
      END;
      I use this function tu return th value of a sequence field in an insert istruction.

      When i call this SP from my .net program (i use ODP dirver vers. 2.102.2.20) i recieve the error:
      We recieve ORA-06502: PL/SQL: numeric or value error
      ORA-06512: at line 1 on some updates.

      If i call the same SP with OleDB provider all works fine.

      SYSTEM:

      Thanks for help.
      A.T.