Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Stored Procedure and User-Define Functions
Stored Procedure and User-Define Functions [message #45212] Wed, 11 June 2008 05:19 Go to next message
Eclipse UserFriend
Originally posted by: seamonster76.yahoo.com

Hi,

I'm implementing a JDBC driver for my own data base.
When I use the Data Source Explorer, the stored procedures in my system end
up showing under the User-Defined functions. I debug my driver and the
stored procedures are returned by my getProcedures() implementation. Why
does DTP take them as user defined functions?

Also, is there a way to invoke a stored procedure with a few input
parameters? I don't seem to see how I can do it in the UI.

Any help is appreciated.

Thanks
Andy
Re: Stored Procedure and User-Define Functions [message #45481 is a reply to message #45212] Mon, 16 June 2008 02:22 Go to previous message
Eclipse UserFriend
Originally posted by: hui.cao.sybase.ocm

Andy,
To invoke procedural objects, just right click and choose "run...",
parameter configuration dialog will show up. Alternatively, you can go to
"Run dialog" and create a DTP launch configuration.

Regards.

Max (Hui) Cao
Sybase Inc.

"Andy Lai" <seamonster76@yahoo.com> wrote in message
news:g2nn9v$5b3$1@build.eclipse.org...
> Hi,
>
> I'm implementing a JDBC driver for my own data base.
> When I use the Data Source Explorer, the stored procedures in my system
> end up showing under the User-Defined functions. I debug my driver and the
> stored procedures are returned by my getProcedures() implementation. Why
> does DTP take them as user defined functions?
>
> Also, is there a way to invoke a stored procedure with a few input
> parameters? I don't seem to see how I can do it in the UI.
>
> Any help is appreciated.
>
> Thanks
> Andy
>
>
>
Re: Stored Procedure and User-Define Functions [message #591469 is a reply to message #45212] Mon, 16 June 2008 02:22 Go to previous message
Hui Cao is currently offline Hui CaoFriend
Messages: 29
Registered: July 2009
Junior Member
Andy,
To invoke procedural objects, just right click and choose "run...",
parameter configuration dialog will show up. Alternatively, you can go to
"Run dialog" and create a DTP launch configuration.

Regards.

Max (Hui) Cao
Sybase Inc.

"Andy Lai" <seamonster76@yahoo.com> wrote in message
news:g2nn9v$5b3$1@build.eclipse.org...
> Hi,
>
> I'm implementing a JDBC driver for my own data base.
> When I use the Data Source Explorer, the stored procedures in my system
> end up showing under the User-Defined functions. I debug my driver and the
> stored procedures are returned by my getProcedures() implementation. Why
> does DTP take them as user defined functions?
>
> Also, is there a way to invoke a stored procedure with a few input
> parameters? I don't seem to see how I can do it in the UI.
>
> Any help is appreciated.
>
> Thanks
> Andy
>
>
>
Previous Topic:execution plan
Next Topic:Execute SQL in the run toolbar button?
Goto Forum:
  


Current Time: Thu Apr 25 01:43:30 GMT 2024

Powered by FUDForum. Page generated in 0.02873 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top