DSXchange

Quest "Are you able to execute the procedure in the DB environment by using the same id that was used to run SP from DataStage? " yes I can run the same SP from SQL plus. It works fine there but in DS it is giving the error mentioned. Is it because execute Immediate statement. I also tried...

Hi, Thanks for your reply. I tried with stored procedure to do the same. However though the same proceudre executes from SQL Plus prompt it gives error 'ORA-06512' in the warning in datastage and does not create a the backup table. The user id that we are using to run the stored procedure from DS ha...

Thansk for your reply.
However, we want to do the same without using a stored procedure as the client does nto want objects outside DS objects. So any other suggestions would help.

Hi, I am trying to create a backup of an existing table dynamically in datastage job. I do this using ODBC stage for connecting to an Oracle table and in userdefined SQL i give SQL as create table xyz_backup as (select * from XYZ); Till this point it works. however the requirement is to create the b...