This content has been marked as final. Show 4 replies
open the physical table properties-->general -->we will find a drop-down
there you can select the stored procedure..
mark if helpful/correct..
I know that from the drop down we can choose the Stored Procedure option,
but i would like to know how to provide the details of the Stored Procedure to populate the table??
It would be nice if we know more details about 'Populating table'...
Using connection pool->connection pool scripts tab you may go for inserting/updating (Populating table) records into table.
It would be nice if you use dedicated connection pool for init blocks...
Ex: I want to insert user login time some xyz table my query would be like
insert into xyz values ('valueof(NQ_SESSION.USER)',sysdate)
without knowing your requirements its hard to tell anything apart from what is said.
If helps pls mark
Edited by: Srini VEERAVALLI on Jan 16, 2013 10:37 PM
I would just like to Know how to use this option of Stored Procedure in the Table Type property???