DSXchange

It does not help, i tried running this in a standalone job with only stored procedure stage. the error i got is Stored_Procedure_45: OCIAttrGet - Must be an anonymous pl/sql block being prepared. Stored_Procedure_45,0: Error occurred in call to ORPHCallActivePluginInitialize(). Stored_Procedure_45,0...

No specific reason, i just wanted to do it in a job after load is done.

ArndW wrote:A quick Google search shows that the ORA-0900 error has more to do with the call than the procedure itself. Have you tried using double-quotes instead of single quotes in the call?

Double quotes also gave me the same error.

ArndW wrote:Did you add a semicolon at the end of the command? ...

Yes, semicolon is included. The sql works fine in toad

Can we execute stored procedure from After SQL statement in oracle connector stage? I get a error when i run the same...The following SQL statement failed: EXEC DBMS_STATS.gather_table_stats('XYZ','TABLE_NAME',method_opt => 'for all columns size auto'). TABLE_NAME: [IIS-CONN-ORA-001003] The OCI func...

i need to send a mail to sourcing team, in the body of the mail i should mention 107 records have been rejected. this count 107 should be inserted in the body of the mail For sending the mail i am using Dssendmail routine in the afterstage subroutine In the Dssendmail routine inside the body of the ...

this is how i code in the afterstage subroutine From:abc@x.com\nTo:cba@x.com\nserver:x.com\nAttach:D:\Seq_reject.txt\nBody:%DSGetLinkInfo(DSJ.ME,DSJ.ME,DSJ.ME,DSJ.LINKROWCOUNT)% reject found \n%report% can we use the DsFunction inside the body of the Dssendmail subroutine, if yes is the syntax right...

What have you tried? And define 'rejects' in this context as sequential files don't typically generate reject records. ... its not the reject comes out of seq file. its from the xfm stage where records are rejected with a constraint set in xfm stage. using @outrownum i can have the number of record...

I would like to send a mail to sourcing team about rejects. I am using Dssendmail subroutine in the after subroutine stage(xfm stage). i need to include the no of records rejected in this routine to be sent out in the mail. My job design is src----xfm---seq file - - - - Reject seq file

i need to send mail notification only if some records (i.e reject count>0) are rejected in a particuar stage.
Currently i am using Dssendmail routine in transformer stage to send out a mail in the after stage subroutine.
Can some constraits be imposed for the after subroutine to initiate

I am trying to backup the existng file in remote location, before sending the new file. I am using the Ftp plug in stage. I have set the following properties Backup file - Yes Telnet Backup commnad - mv a.log b.log move a.log b.log Also the file is in \ and not in any directory Director gives the fo...