How do you execute an Oracle stored procedure?

Highlighted
Five Stars

How do you execute an Oracle stored procedure?

Hello,

I have a stored procedure (Oracle) that executes clean (with no errors) in Oracle SQL Plus/ Toad. Here's how I run it:

exec cm_process_files_sp

When I run this in TOS using a tSQLRow, I get errors like 'exec' is not recognized, nor is my stored procedure name (cm_process_files_sp) recognized... I've also tried running it in double quotes ("exec cm_process_files_sp") - still didn't work...

Please let me know what I am doing wrong...

Thanks a lot in advance...

PS: I'm using the Java compiler

Will
Highlighted
One Star
One Star

Re: How do you execute an Oracle stored procedure?

HI,
I use a tOracleRow, I write in query a pl/sql code:

"begin NAME_OF_THE_PROCEDURE(PARAMETER); end;"

Regard Smiley Wink
Highlighted
Five Stars

Re: How do you execute an Oracle stored procedure?

Thanks a lot! I'm sure this will work since you've tested it before... I appreciate your help...

Will

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog