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