here is the part of my Delphi code where am trying to create a stored
procedure...

SQLQuery1.SQL.Add( 'CREATE PROCEDURE SPGETDRID_TEMP( DRID VARCHAR(50))
RETURNS (RET_DRID VARCHAR(50)) AS');
SQLQuery1.SQL.Add( 'BEGIN');
SQLQuery1.SQL.Add( 'SELECT DR_ID FROM TEMPDRS WHERE DR_ID = :DRID INTO
RET_DRID;');
SQLQuery1.SQL.Add( 'SUSPEND;');
SQLQuery1.SQL.Add( 'END');

try
TD.TransactionID := 2;
TD.IsolationLevel := xilREADCOMMITTED;
SQLConnection1.StartTransaction(TD);
SQLQuery1.ExecSQL;
SQLConnection1.Commit(TD);
except on e: EDatabaseError do
begin
SQLConnection1.Rollback(TD);
LogFile.Log(e.Message);
end;
end;

am getting an ERROR saying "No Value for parameter 'DRID'." and its
exiting.. without creating...
and the same code is working very fine with IBAccess when I tried create it
manually.

any help greatly appreciated...
Kiran Kumar.

-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: Wednesday, February 12, 2003 6:59 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Help On Stored Procedures


Hi,

> is there any documents / ebooks available on the net on Stored Procedures

?

> like ...
> how do I create them ?
> how do I access them ?
> a kind of Introduction or lets say examples ???
>
> am using FIREBIRD, I have created a small Stored Procedure thru IBAccess
> which is working fine, but when I tried create the procedure with my

Delphi

> 6 Application its giving an error. I am curious to know how do I create

them

WHAT error?

> ? and where do I place them ? just just help me out with some examples..

or

What do you mean "where do I place them?"??

[Kiran] I mean to say.. will I have to write a script and where do I place
it on the server ?
With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com <http://www.upscene.com>

"This is an object-oriented system.
If we change anything, the users object."


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]