Re: EXECUTE ANY PROCEDURE

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 15 May 2007 20:00:26 +0200
Message-ID: <f2d1es$6ni$1@news4.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jeff Kish schreef:
> On 14 May 2007 13:21:51 -0700, fitzjarrell_at_cox.net wrote:

>> The problem lies in the user name; you cannot simply start usernames
>> with a number.  You might try this:
>>
>> select * from "22a".assetnew;
>>
>> The user account was obviously created using double quotes; you need
>> to continue using them to access objects owned by that user.
>>
>>
>> David Fitzjarrell

> Thanks .. this turned out to explain the problem.
> I had tried the following with only the indicated success:
>
> select * from 22a.assetnew; unsuccessful
> select * from "22a".assetnew; unsuccessful
> select * from 22A.assetnew; unsuccessful
> select * from "22A".assetnew; successful
>
> So it was a combination of quotes and I guess the quotes lead to case
> sensitivity.

Yes - as documented

>
> I didn't realize there was a problem or restriction or consequence of using a
> username beginning with a number.

Documented, too, of course.

>
> Thanks much for returning my sanity to me, and thanks everyone else for your
> comments/suggestions etc.
> Jeff Kish

Which just shows not to simplify the issue at hand: there was absolutely no indication why the 903 would occur from the initial postings.
Sybrand was correct (once again) in his assumption these were not the real names.

Once you posted the user (22A) it became quite obvious what the issue was.
- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGSfU6Lw8L4IAs830RAvGuAJ9oVrTJ75LOAF4YFEhczrMkI0RFPACfcAuN 8rXoxjJ49GX6CHyXdybB8cM=
=iqFc
-----END PGP SIGNATURE----- Received on Tue May 15 2007 - 13:00:26 CDT