Re: Problem with sequences

You are probably running under a different user in the DBI interface. The owner of the sequence needs to give select privilege to that user, and that user needs to create a private synonym. If you have different users you may want the grant select to public and create a public synonym.

Hth,

--
Sybrand Bakker, Oracle DBA
Marc Cluet <mcluet_at_worldonline.es> wrote in message news:3833d4af.8104984_at_news.worldonline.es...
> Hi
> I'm advancing a sequence in SQL Worksheet and it advances correctly
> making a
> select SEQ_SEND.nextval from DUAL;
>
> But if I try to do the same under a DBI interface I'm programming into
> (PHP) it shows the error that the sequence doesn't exist, any hint
> that I could find into?
> Thanks
> Marc
Received on Thu Nov 18 1999 - 14:15:13 CST