Hi,
Oracle is new to me. But from the otn.oracle.com, the
explaination given for your error code:
-------------------
ORA-00928 missing SELECT keyword
Cause: A SELECT subquery must be included in a
CREATE VIEW statement.
Action: Correct the syntax. Insert the required
SELECT clause after the CREATE VIEW clause and then
retry the statement.
--------------------
Did you try to do some CREATE VIEW statement in you
SQL command??
Hope this help...
--- "Gaul, Ken" <[EMAIL PROTECTED]> wrote:
> Has anybody ever encountered the ORA-00928 error
> while executing a
> pre-prepared insert statement?
> The parse succeeds OK, the bindings seem to happen
> OK, but during the
> dbd_st_Execute INSERT (out0,lob0).... phase of
> execution the error is
> thrown. The DB error is just (DBD ERROR:
> OCIStmtExecute) on
> DBI::st=HASH........
>
> I've checked metalink and other archives all to no
> avail, has anybody any
> idea why I would get missing select on an insert
> statement?
>
> Environment:
> DBI version 1.20
> DBDOracle version 1.12
> Oracle 8.1.7.2
> Sun Sparc Solaris 7
>
> TIA,
>
> Ken.
> <<Ken Gaul.vcf>>
>
> ATTACHMENT part 2 application/octet-stream name=Ken
Gaul.vcf
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com
