powercenter SQL Trans Query Mode :Multiple SQL statements Issue

Problem Definition:

In Informatica Powercenter 9.0.1(can be applicable to other versions)we want to create multiple dynamic SQL statements with SQL transformation in Query mode,then we have encountered following error:

ORA-00911 : Invalid Character Database Driver error

Input Data :’insert into TEST_TABLE values(1) ; insert into TEST_TABLE values(2) ; insert into TEST_TABLE values(3);’

 Solution:

Modify your SQL with BEGIN and END Clause

‘BEGIN’|| CHR(10)||‘insert into TEST_TABLE values(1) ; insert into TEST_TABLE values(2) ; insert into TEST_TABLE values(3);’||’END;’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s