Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL vs PROC Performance Issue - Oracle 8.1.6

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

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Sat, 21 Jul 2001 21:35:35 GMT
Message-ID: <3B4EE250.13B6DDC0@unilog.fr>

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.

>

>...

> >
> > Daniel A. Morgan
> >
 
-- 
 Pierre CHARPENAY
Received on Sat Jul 21 2001 - 16:35:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US