Another list for code search. Good then google.
http://www.koders.com/
http://www.bigbold.com/snippets/
http://www.krugle.com/
10x,
Ankur Dave
-Original Message-
From: Philipp Schwarz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 11, 2006 12:30 PM
To: php-db@lists.p
Hi,
Can anyone help. I'm trying to access an out parameter from an Oracle
Stored Procedure. But I get the following message. I think it might have
something to do with the configuration of our server but I'm not sure.
Warning: ociexecute(): OCIStmtExecute: ORA-06550: line 1, column 20:
PLS-00553:
I have a script that creates a table copy using SELECT INTO, but I want it
to check if the new table already exists first. Does SQL support the EXISTS
keyword for SELECT INTO statements (I'm running PG7)?
If not, is there another way to do it in SQL? I'd rather not do it
programmatically.
Thanks
My advice:
Do a "drop table" first, ignoring any error that will result if it does not
exist, then do the "select
into". This is portable, too...
> I have a script that creates a table copy using SELECT INTO, but I want it
> to check if the new table already exists first. Does SQL support the E
Thanks Mike. Luckily, I donĀ¹t need the data if the table already exists so
that should work.
Tony
On 10/11/06 2:53 PM, "Mike Morris" <[EMAIL PROTECTED]> wrote:
> My advice:
>
> Do a "drop table" first, ignoring any error that will result if it does not
> exist, then do the "select into". This
PLS-00553: character set name is not recognized ORA-06550: line 0,
The error message gives you a lot of detail.
Does this work ok if you don't do it through php but directly through
oracle?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www
Tony Grimes wrote:
I have a script that creates a table copy using SELECT INTO, but I want it
to check if the new table already exists first. Does SQL support the EXISTS
keyword for SELECT INTO statements (I'm running PG7)?
If not, is there another way to do it in SQL? I'd rather not do it
progr