calling pl/sql BLOCK from .NET

From: Channa, Santhosh <Santhosh.Channa_at_McKesson.com>
Date: Wed, 7 Oct 2009 18:06:51 -0400
Message-ID: <A1DEC407B8BBA84CA6CA498AA39CF54803EC5717_at_NDHV3001.na.corp.mckesson.com>

All,

I know its not a .NET list but have a question and need your input/suggestion/hint on the issue that i have. I need to call a pl/sql block from .NET application. The reason for pl/sql block is because i want to write some dbms_outputs and spool it to a file. As for as my knowledge concern there is no way that i can use any of these "set","spool" variable commands using execute immediate or anything so it has to be like a pl/sql block.

Have its own limitations (in the requirements) using utl_file so that option is kinda blocked...

Any hints are appreciated.

Regards,
Santhosh Channa

P Consider the environment. Please don't print this e-mail unless you really need to.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 07 2009 - 17:06:51 CDT

This message: [ Message body ]
Next message: Jaromir D.B. Nemec: "Re: Enable Parallel DML or Not?"
Previous message: Jared Still: "Re: Is there an option for insert statements/DML to be captured similar to DDLs generated with import imp show=y"
Next in thread: Jared Still: "Re: calling pl/sql BLOCK from .NET"
Reply: Jared Still: "Re: calling pl/sql BLOCK from .NET"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message