Earlier this month here we were running into an old bug in the oracle driver, described here: http://ccm.redhat.com/bboard-archive/webdb/000Ya9.html
In the ns_ora exec_plsql command the return buffer was not being given a null terminator (or, as is the case in other bind calls, completely filled with nulls) after being allocated. I added a memset call so it acts here like in other ns_ora functions that use bind variables, which so far has solved the problem. Perhaps this would be useful for the next release of the oracle driver... (patch below) -- jesse kipp [EMAIL PROTECTED] --- ora8.c~ 2002-10-03 14:05:58.000000000 -0600 +++ ora8.c 2003-06-24 17:42:17.000000000 -0600 @@ -3338,6 +3338,7 @@ } buf = Ns_Malloc(EXEC_PLSQL_BUFFER_SIZE); + memset(buf, (int)'\0', (size_t)EXEC_PLSQL_BUFFER_SIZE); oci_status = OCIBindByPos (connection->stmt, &bind, -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.