Executing Stored procedure from Ibconsole

Thread View: borland.public.interbase.ibconsole

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Alain Thu, 23 Aug 2007 06:52

#161

Author: Alain
Date: Thu, 23 Aug 2007 06:52

7 lines
1028 bytes

Hi,
  Can someone help me out on how to execute a store procedure in ISQL
IBConsole ?

Thanks

Alain

Re: Executing Stored procedure from Ibconsole

#162

Author: Craig Stuntz TeamB
Date: Thu, 23 Aug 2007 13:25

12 lines
1446 bytes

Alain wrote:

>  Can someone help me out on how to execute a store procedure in ISQL
> IBConsole ?

	EXECUTE PROCEDURE FOO(ARG1, ARG2);

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
All the great TeamB service you've come to expect plus (New!) 
  Irish Tin Whistle tips: http://learningtowhistle.blogspot.com

Re: Executing Stored procedure from Ibconsole

#163

Author: Quinn Wildman (CodeGear Develope...
Date: Thu, 23 Aug 2007 14:53

15 lines
1194 bytes

If the stored procedure returns a result set:

select * from foo (arg1, arg2)

Alain wrote:
> Hi,
>   Can someone help me out on how to execute a store procedure in ISQL
> IBConsole ?
> 
> Thanks
> 
> Alain
> 
> 
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads