Error in Trigger Generation in Oracle

Posted Date: 16 Sep 2008	Resource Type: Errors and Solutions	Category: General
Author: Prafulla S Shimpi	Member Level: Gold
Rating:	Points: 5

When creating new tables limit the name of the table to 29 characters (rather than the Oracle limit of 32 characters).

The reason for this is that the automatic trigger generator for Audits and Last update fields uses the table name plus “_LU” and “_AA” AFTER the table name, and as oracle only allows object names of 32 chars triggers cannot be created where the tablename > 29 chars

Responses

Author: Puja Sharma 16 Sep 2008

Member Level: Gold Points : 2

nice information.
very useful to me..

Feedbacks

Popular Tags

What are tags ?

Search Tags

Triggers . Oracle .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: NT AUTHORITY-NETWORK SERVICE does not have write access.
	Previous Resource: Packages
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources