Re: Execute a Function of Oracle in Asp.net

From: <fitzjarrell_at_cox.net>
Date: 10 May 2007 06:37:33 -0700
Message-ID: <1178804253.377101.108910@q75g2000hsh.googlegroups.com>

On May 10, 8:09 am, Kovu <kovut..._at_gmail.com> wrote:
> Version:
>
> - Oracle 9i.
> -Asp.net 2.0.
>
> ^^

'Oracle 9i' doesn't tell us much; report the exact release to 4 numbers. That being said it shouldn't matter which release of Oracle you're connecting to, the syntax for running a stored procedure from, say, SQL*Plus is:

exec <owner>.<procedure name [(any passed parameters)]>;

For example:

SQL> exec dbms_stats.gather_schema_stats([parameters here]);

As you already can pass queries through asp.net to Oracle the mechanism should be simiilar, meaning you build your statement as illustrated and submit it to Oracle.

I expect there are others in the group more qualified to provide asp.net assistance, so I'll leave it to them to correct what I've mentioned (if necessary).

David Fitzjarrell Received on Thu May 10 2007 - 08:37:33 CDT