| Update [message #295385] |
Tue, 22 January 2008 04:15  |
monicaminj2000
Messages: 1
Registered: January 2008
|
Junior Member |
|
|
could youplease tell me wat dis statement is going to do????
updateSql:='Update ' || DataTable || ' Set RECORDSTATUS = :1, RESPONSEXML = EMPTY_CLOB() , RECORDRESULT = :2, RECOVERYNUMBER = :3 Where RECORDKEY = :4 RETURNING RESPONSEXML INTO :5';
|
|
|
|
| Re: Update [message #295395 is a reply to message #295385] |
Tue, 22 January 2008 04:32  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
it is going to assign the value of 'Update ' || DataTable || ' Set RECORDSTATUS = :1, RESPONSEXML = EMPTY_CLOB() , RECORDRESULT = :2, RECOVERYNUMBER = :3 Where RECORDKEY = :4 RETURNING RESPONSEXML INTO :5'
to the string variable updatesql for use within an execute immediate statement later in your procedure.
I would suggest that yopu do a dbms_output of the variable to see exactly what string has been built.
PS
wat and dis are not words. please refrain from using IM speak on these forums.
1. It makes it more difficult to understand your post.
2. It is unprofessional.
3. It is irritating to most people.
Cheers
[Updated on: Tue, 22 January 2008 04:34] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
