Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6

uunet a écrit :
>
> ...
> VARCHAR dynstmt[80];
> ...
> strcpy ( (char *) dynstmt.arr,
> "UPDATE EMP SET "
> "ENAME = 'EMP_NAME_X',"
> "JOB = 'EMP_JOB_X', "
> "MGR = 1234, "
> "HIREDATE = SYSDATE, "
> "SAL = 12345.67, "
> "COMM = 12345.67, "
> "DEPTNO = 12 "
> "WHERE EMPNO = :v1"
> );
>
> dynstmt.len = strlen((char *)dynstmt.arr);

dynstmt.len will contain 202 ! You string is too long for the VARCHAR of 80 ! At this point, the reactions of the program are unpredictable ...

Try with a VARCHAR of 250.

>

>...


> >

-- 
 Pierre CHARPENAY