Print Page | Close Window

Alter Table on Connection

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=2574
Printed Date: 18 Apr 2025 at 10:47pm


Topic: Alter Table on Connection
Posted By: Ghauri
Subject: Alter Table on Connection
Date Posted: 11 Mar 2008 at 12:03am
Hi all,

I have got a confusion.

    I am using Crystal Report X, Oracle Database, JDBC drivers.

I have a schema on which I have applied a trigger to restrict any Alter command.
   
    When I make connection in crystal reports, I can make connection, but I can't select and include table(s) in database expert. An error occurs:

Trigger throws that error
ORA-20000: Cannot Alter Database, Consult your DBA

When I disables that trigger the tables would includes without error.

I am surprised that, Does Crystal Report Alter Table(s) on the time of including tables to make query???
If Yes then which are those table(s)???



-------------
Thanks & Regards,
Ghauri



Print Page | Close Window