Home » SQL & PL/SQL » SQL & PL/SQL » change parameter of sqlplus from pl/sql procedure ?
change parameter of sqlplus from pl/sql procedure ? [message #4492] Sun, 15 December 2002 03:57 Go to next message
arik
Messages: 1
Registered: December 2002
Junior Member
hello.
all my question are for SqlPlus interface.
1. is there a way to change parameters in sqlplus (e.g: sqlp, serveroutput, etc') from a procedure ?
2. i've created a trigger on logon that print "hello" when a user login, but it never did show the output although the serveroutput was on, and for debuging purose i could see that it inserted values to table, so the trigger works fine.

thanks... ;-)
arik.

Report message to a moderator

Re: change parameter of sqlplus from pl/sql procedure ? [message #4494 is a reply to message #4492] Mon, 16 December 2002 01:17 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
to do that job, u need not go for logon triggers...

open glogin.sql file and add the below lines

Prompt "Welcome "

sai

Report message to a moderator

Previous Topic: primary key then index necessary???
Next Topic: Attention Todd Barry or Andrew
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 03:56:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.