Need help!!! I am writing an sp that uses a cursor to get the rowid and
it passes as upper case. Is there a way to get the cursor to preserve
the case?

Thanks,
JC

"JC" <joseph.chewning@targacept.com> wrote in news:1143492141.426049.196160
@i40g2000cwc.googlegroups.com:

> Need help!!! I am writing an sp that uses a cursor to get the rowid and
> it passes as upper case. Is there a way to get the cursor to preserve
> the case?
>


I have never been concerned about the case of a ROWID.
Why is it a problem for you?
What problem are you really trying to solve.
Most problems do not require ROWID to be part of the solution.

Ianal,

Never mind I found an awsome tool for debugging PL/SQL and it is by
oracle....

http://www.oracle.com/technology/sof...sql/index.html

It is new to me, look like they are trying to keep up with SQL 2005...

Thank for getting back to me!!!

JC wrote:
> Ianal,
>
> Never mind I found an awsome tool for debugging PL/SQL and it is by
> oracle....
>
> http://www.oracle.com/technology/sof...sql/index.html
>
> It is new to me, look like they are trying to keep up with SQL 2005...
>
> Thank for getting back to me!!!

"Keep up with SQL 2005 ..."

ROFL!
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

DA Morgan wrote:
>
> "Keep up with SQL 2005 ..."
>
> ROFL!

Behave yourself, Daniel. Microsoft have done a fantastic job of making
SQL Server extremely pretty to look at and very easy to use. All this
by merely sacrificing scalability and reliability!

:-P

gazzag wrote:
> DA Morgan wrote:
>> "Keep up with SQL 2005 ..."
>>
>> ROFL!
>
> Behave yourself, Daniel. Microsoft have done a fantastic job of making
> SQL Server extremely pretty to look at and very easy to use. All this
> by merely sacrificing scalability and reliability!
>
> :-P

You are, of course, correct. I am sooooo ashamed.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

JC wrote:
> Need help!!! I am writing an sp that uses a cursor to get the rowid and
> it passes as upper case. Is there a way to get the cursor to preserve
> the case?
>
> Thanks,
> JC
>


http://www.techonthenet.com/oracle/functions/index.php

Try looking the Lower and Upper functions

-Mf2