![]() |
Hi
15 Sep 2014
| 5 comments
,
|
![]() |
Hi All, Recently someone told me that using Dynamic SQL in TD procedure is not a good practice for performance reasons. Is that true? Does it mean that for every procedure call procedure needs to re-compile? Is there any way to avoid dynamic sql completely? Parameterizing query is something which I can not avoid. Thanks
22 Dec 2011
,
|
![]() |
Hi, I am executing a SQL using DBC.SYSEXECSQL in a Store Procedure . Can any one suggest me way to capture the activity count of sql executed Regards Anand Louis
03 Nov 2011
| 4 comments
,
|
![]() |
I'm attempting to develop a stored procedure that takes a table name as a parameter, and performs column-by-column updates to whatever table is passed in. I have the dynamic SELECT query working correctly: SET CURSOR_SQL = 'SELECT * FROM ' || P_TABLE_NAME || ' ORDER BY rsid;'; Now I'm at the point where I need to fetch the cursor data into local variables...but I can't create table-specific local variables because I don't know what tables will be passed into this procedure.
01 Aug 2011
| 4 comments
,
|
![]() |
SET dyn_sql = SET dyn_sql = I get this when above is called. compiles correctly. 5568 SQL statement is not supported within a stored procedure. What I am trying to do is call a stored procedure to work on specific table. I can get table name as an input parameter or sel from a table.
15 Jul 2010
,
|