Home » SQL & PL/SQL » SQL & PL/SQL » Setting variables
Setting variables [message #39779] Fri, 09 August 2002 09:38 Go to next message
help
Messages: 5
Registered: September 2000
Junior Member
I am trying to set a variable that will bring back an answer. It will not let me do this select statement in an afterreport trigger. WHY?

SCenter := Select distinct Service_center from v_Productivity where svc_resrc_gen_key = 77;

Report message to a moderator

Re: Setting variables [message #39780 is a reply to message #39779] Fri, 09 August 2002 12:00 Go to previous message
null null
Messages: 2
Registered: August 2002
Junior Member
post your code so we can see what you're trying to do.

Report message to a moderator

Previous Topic: Passing record values to a stored procedure
Next Topic: ORA-01008: not all variables bound
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 19:00:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.