console out feature 1

[palovidiu]

using "SQLPlus Worksheet", sql query console provided by
Oracle .. or "sql plus" , and not some fancy shmancy TOAD or SQL navigator I would like to do this :

--run this pl/sql block
declare
someText VARCHAR(100);
begin
someText:='some trivial message for the masses';
select someText as Message from dual;
end;


--and get something like
Message
-------

some trivial message for the masses

the example doesn't work, it sugest to use INTO clause
in the select ..

I would like then in conclusion , to be able to return
non-numeric output from inside a pl/sql block ..

anyone has some ideea ?

thank you

 

[Dagon]

It's objecting to this line:

select someText as Message from dual;

You need to select INTO a variable.

 

[sem]

Most probably you need dbms_output.put_line instead of mixing pl/sql with pure sql.

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Palo,

Building upon Sem's (Dima's) correct suggestion (since the method can be somewhat problematic for the uninitiated user), here is a code segment that illustrates the concept (from a SQL> prompt):

set serveroutput on
declare 
  someText VARCHAR(100);
begin
  someText:='some trivial message for the masses';
  dbms_output.put_line(someText);
end;
/
some trivial message for the masses

Let us know if this is useful.

P.S. Sem/Dima, did you receive my e-mail message several days ago? Please let me know, either way.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[sem]

Another option is (a code for sql*plus):

var rc refcursor

declare
  someText VARCHAR(100);
begin
  someText:='some trivial message for the masses';
  open :rc for select someText as Message from dual;
end;
/
print rc

Regards, Dima

http://seminihin.narod.ru

 

[SantaMufasa]

Sem, did you receive my e-mail from a few days ago?

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[ddiamond]

Dima,

I had know idea you could declare variables and print cursors outside of a pl/sql block. That's good to know.

- Dan

 

[palovidiu]

thanks,

yes it is dbms_output.put_line, i found out for my self
on the same day I posted the message.

thank you for the help