ORA-03113 when passing VARRAY into OCI external procedure.

From: Alexander Kalinushkin <ask_at_rust.formoza.ru>
Date: 27 Aug 2001 01:50:25 -0700
Message-ID: <229eada2.0108270050.8cee4c1@posting.google.com>

I'm OCI newbie - just started using it.
And i'm getting "ORA-03113: end-of-file on communication channel" when trying to pass VARRAY into external procedure.

// My C function (Using MSVC 6.0 and Oracle 8i on Windows NT) int __stdcall coltest(OCIArray * oraclearray) {
  int result = 0;
  return result;
}

• PL/SQL declaration of my external routine CREATE OR REPLACE FUNCTION dll_coltest ( xtab IN pdlltest.varr) RETURN BINARY_INTEGER AS EXTERNAL LIBRARY dlltest NAME "coltest" LANGUAGE C;
• pdlltest.varr declaration create or replace package pdlltest is TYPE varr IS VARRAY(2) OF NUMBER; end pdlltest;
• test code SQL> /

DECLARE
  xtab pdlltest.varr;
  result NUMBER;
BEGIN
  xtab:=pdlltest.varr(1,3);
  result:=dll_coltest(xtab);
END; ORA-03113: end-of-file on communication channel

What am I doing wrong? Received on Mon Aug 27 2001 - 03:50:25 CDT