11-26-2013 02:27 PM
lr_db_connect("StepName=myStep", "ConnectionString=Initial ConnectionString=DATA SOURCE=jdbc:oracle:thin:@p2pyak-vip.es.ad.adp.com:
lr_db_executeSQLStatement("StepName=MyStep", "ConnectionName=MyConnection", "SQLQuery=SELECT * FROM Addresses", "DatasetName=ds1", LAST);
I got below error:
Error -- Unresolved symbol : lr_db_connect.
11-26-2013 04:00 PM
You are using the oracle 2 tier protocol? Else the neccessary headers for db need to be imported explicitly.
Next step, note you need a list of stuff such as Ora handle, Ora Session etc that you need to setup before connect.
I dont have a sample script, but you could check in the help and use the examples provided.