ETL and Data Integration tools - Modern ETL software for everyone

Hi

I am connected to an Oracle database via ODBC and I am trying to use the SQL scripts to call a pocedure with in a package

the code I am using is

execute schema_name.Package_name.procedure_name;

However the procedure does not fire. I have called the procedure from within Oracle and all works fine.

Any ideas on what could be wrong, or is this not possible

Thanks

Emile

if you run it from sql editor by pressing green arrow does it work?

I believe it should be

begin
procedurename;
end;

Read this as well
www.dbsoftlab.com/forum/how-to-get-help-today.html

Mike

Hi

No it doesnt run when just clicking the green arrow, I created a batch file that solved the issue anyway

your link was very educational

thanks

Emile

We really would like to help you with this problem so other users will benefit

Can you have a look at the attached screen shot and post simular

I have ommited the package names as I dont want them to be visible to people

thanks


begin
schema.package.procedire;
end;

Following Error happened:
ORA-01861: literal does not match format string
ORA-06512: at "schema.package", line 414
ORA-06512: at "schema.package", line 160
ORA-06512: at line 2