--- In firebird-support@yahoogroups.com, "mauleen2006"
<mauleen2006@...> wrote:

>
> Hello,
> We are facing a problem creating a stored procedure at the
> front-end (VB.Net).We use the following Code snippet to create the
> stored procedure at the front-end :-
>
> Dim a As String = "CREATE PROCEDURE PROC1 (" & Chr(13) & _
> "PRF INTEGER,FID VARCHAR (10) CHARACTER SET ISO8859_1)" & Chr(13) & _
> "AS" & Chr(13) & _
> "Declare variable OID varchar(6);" & Chr(13) & _
> "BEGIN" & Chr(13) & _
> "SUSPEND;" & Chr(13) & _
> "End""
>
> Dim fbcmd As FbCommand = New FbCommand(A, fbcon)
> fbcmd.ExecuteNonQuery()
>
> We get the Exception when we execute the above command:-
> "FirebirdSql.Data.Firebird.FbException: Dynamic SQL Error
> SQL error code = -817
> Metadata update statement is not allowed by the current database SQL
> dialect 1.
>
>
> What could be the solution for the above problem?
>
> Thank you,
> Meghna
>

Set Term ^ ;
do your stuff
Set Term ; ^


Mick