I'm trying to get output parameter of this stored procedure from Oracle:

CREATE OR REPLACE PROCEDURE TEST(L OUT VARCHAR2) IS
BEGIN
L:='111';
select 'HELLO' into L from dual;
END TEST;

But it gets "Parameter object is improperly defined" error, i am following
the guide from this web page http://www.sqlis.com/default.aspx?58). Help,
please help!

fastfood
Thx

Hello fasfood,

How have you defined the Parameter mappings. This is, unless I am much mistaken,
Oracle. In the article I am going against an OLEDB Connection. Perhaps
you are using the Managed Oracle Connection Manager. Did you follow the
link through to

http://www.sqlis.com/default.aspx?81

Allan

Hi Allan Mitchell,

Thanks for your help. But I have followed this
http://www.sqlis.com/default.aspx?81 and use ADO to connect Oracle. I still
get this error. Please help!!!! It seems SSIS only support SQL Server stored
procedure because i can use output parameter with SQL server 2005.

thx
fastfood

"Allan Mitchell" wrote: