Inserting into Oracle table from Server Rouitne

srekant · Post by **srekant** » Sat Jan 21, 2006 5:01 am

Hi,

How can i insert into Orcale table from a server routine
Any help is appreciated

kumar_s · Post by **kumar_s** » Sat Jan 21, 2006 5:26 am

Hi,

Pls search the forum for best result.

In your routine use the DSExecute API to run system commands. By running sqlplus with the appropriate information you can get the results.

-Kumar

chulett · Post by **chulett** » Sat Jan 21, 2006 8:30 am

Alternately, you might want to post why you think you need to do this. Many people here would be more than happy to suggest alternative approaches that may work out better in the long run for you.

ray.wurlod · Post by **ray.wurlod** » Sat Jan 21, 2006 3:40 pm

Derive the value in your routine, return it to the calling job, and use a stage type (OCI or ODBC) to insert row into Oracle table.

You've spent all that money on GUI software so that you can write your own ETL code? I don't think so.