Hello everyone,
I am using AOLserver 3.3+Ad12 with the latest version of the ArsDigita
Oracle driver. I am seeing an intermittant problem when making calls to
stored functions using 'ns_ora exec_plsql' with a bind value.
Here is the error message:
TCL errorCode = "NONE"
TCL errorInfo:
ora8.c:3348:: error in `OCIStmtExecute ()': ORA-01480: trailing null
missing from STR bind value
SQL:
begin
:1:=cm_ins_categories('S1001', 'fdgfdg', 6, 6, '', 'N', NULL);
end;
while executing
"ns_ora exec_plsql $hDB "
begin
:1:=cm_ins_categories($params);
end;
""
(procedure "cm_ins_categories" line 8)
invoked from within
"cm_ins_categories $db $params"
invoked from within chunk: 0 of
adp: /var/razor/servers/webbasis/pages/cm/category/create_category-2.rml
I know that we have fixed similar problems in the past by invoking plsql
functions with a syntax like 'select <func_call> from dual'. However, that
doesn't work in this case because the stored function has dml statements.
Anyone seen this problem before? We are running Oracle on HPUX-11 and
AOLserver on both Linux (RedHat 6.2) and HPUX-11. We are seeing the
problem on both AOLserver machines.
Please help.
Brian
