Home » Other » General » Clubbing Alter session in SQL (Oracle 11g, Win XP)
Clubbing Alter session in SQL [message #447505] Mon, 15 March 2010 09:58 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
All,

I am here to ask solution for one wiered requirement,
I need to have some way to add Alter session command in the SQL statement.

Alter session set "_gby_hash_aggregation_enabled"= FALSE

I need to have above command to be executed before my SQL statement in the report. In report I can not use two statement
So I need some way to club Alter command and My SQL statement together so that my SQL will work with the report.

any idea is it possible ?


thanks,
freakabhi
"everybody in the work is insane, average of them is called as normal!! "
Re: Clubbing Alter session in SQL [message #447507 is a reply to message #447505] Mon, 15 March 2010 10:02 Go to previous messageGo to next message
ThomasG
Messages: 3092
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
In SQL*Plus you can run the two statements one after the other.

Whether you can do it "in the report" would depend on which tool you use to create the report.
Re: Clubbing Alter session in SQL [message #447509 is a reply to message #447507] Mon, 15 March 2010 10:21 Go to previous messageGo to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
I am using Crusyal report
Re: Clubbing Alter session in SQL [message #447511 is a reply to message #447509] Mon, 15 March 2010 10:35 Go to previous messageGo to next message
ThomasG
Messages: 3092
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
With what programming language?

As far as I know, with Java or C# you open an Oracle connection, and then start the Crystal Report.

Then you could run the alter session on the Connection object before starting the report.
Re: Clubbing Alter session in SQL [message #447530 is a reply to message #447511] Mon, 15 March 2010 14:33 Go to previous message
Littlefoot
Messages: 19350
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If Crystal Reports are anything similar to Oracle Reports, perhaps they have something like "Before Report Trigger" which can be used to execute such a command.
Previous Topic: Temp table
Next Topic: iWare Logic becomes Oracle Gold Partner
Goto Forum:
  


Current Time: Sat Aug 02 01:33:38 CDT 2014

Total time taken to generate the page: 0.09668 seconds