How can we call a package from datastage

daramanoj · Post by **daramanoj** » Tue Sep 07, 2010 5:45 am

Hi,

I have 2 procedures included in a package and i want to call a package from datastage.Can any one plz help me out.

Thanks in advance.

Manoj.

chulett · Post by **chulett** » Tue Sep 07, 2010 6:17 am

Stored Procedure stage.

daramanoj · Post by **daramanoj** » Tue Sep 07, 2010 7:04 am

Are you sure that we can call a procedure inside a package from a stored procedure stage

chulett · Post by **chulett** » Tue Sep 07, 2010 7:07 am

I don't see why not, a proc is a proc, package or otherwise. Have you tried it? Had issues? Have a more specific question?

daramanoj · Post by **daramanoj** » Tue Sep 07, 2010 7:12 am

normally when i want to call a procedure i will use before after tabs in the oci stage .

if the package name is xxx
and procedure name is yyy
i have tried calling like
call xxx.yyy();

but it is giving an error saying "invalid sql statement"

chulett · Post by **chulett** » Tue Sep 07, 2010 7:30 am

Try without the semicolon. I have called packages from the SP stage without issue in the past, any reason not to use it?

arunkumarmm · Post by **arunkumarmm** » Tue Sep 07, 2010 1:23 pm

We are using a lot of SP stage to call pakages and they just work fine. Never had any issues.

daramanoj · Post by **daramanoj** » Mon Sep 13, 2010 2:43 am

normally when i want to call a procedure i will use before after tabs in the oci stage .

if the package name is xxx
and procedure name is yyy
i have tried calling like
call xxx.yyy();

but it is giving an error saying "invalid sql statement"

chulett · Post by **chulett** » Mon Sep 13, 2010 5:57 am

There seems to be an echo in here.

So, is this truly resolved or not? If so, can you share that resolution with us please?