Subject Re: [firebird-support] Timestamp in SP
Author Helen Borrie
At 08:42 AM 2/08/2004 +0200, you wrote:
> >
> > No, not at all. But SQL error -104 is a very broad "parent" for dozens of
> > language validity errors. Can you catch the gdscode? - that's the 9-digit
> > error code.

That's a DSQL error, and there should have been a text message with it.
Could you provide your SP definition and *also* the statement that you are
using in your client app to submit the DDL request?

> >
> > Where did the database come from?
>Firebird 1.0
> > Could it be an ODS 9 database?

If it's an ODS 10.1 database, that might be the source of problems if you
are trying to do this on a Firebird 1.0 server, or you are using a Fb 1.0
client with a Fb 1.5 server. Firebird 1.0 databases are ODS 10, not
10.1. In this case, the thing that prompts the DSQL error is anyone's
guess. It might be thrown, for example, when a Fb 1.0 server finds indexes
on a metadata table that it doesn't think ought to be there. (Indexing on
metadata tables was what prompted the ODS version stepping up at Fb 1.5).

No answers yet, only questions...