Toad World® Forums

Trigger on CLOB fields - No Dice in Schema Browser


#1

#2

We have to update clobs like this, otherwise, you would be limited in the amount
of data you could stick into a lob using the grid.

UPDATE “JDORLON”.“CLOB_TBL”

SET

“COL2”=EMPTY_CLOB()

WHERE

“ROWID” = :“Old_ROWID”

RETURNING

“COL2”

INTO

:“COL2”

I believe this is why your trigger is not catching it.


#3

Oh, I didn’t say it, but we set the data using the COL2 parameter.


#4

Questions? Try the on-line FAQ:
http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See
http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully
Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

,.,_
att1.dat (43 Bytes)


#5

Questions? Try the on-line FAQ:
http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See
http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards? Go here to find out more

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully
Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

,.,_
image004.gif


#6

I had a similar problem in a test I was doing by trying to INSERT into a CLOB a
concatenation of two values each RPADed to 4000. The INSERT ignored the
concatenation.

But I was able to use the SET operation of an UPDATE to update the value with a
concatenation of RPADed to 4000 values. So I inserted a NULL into the CLOB and
then updated it.
image001.jpeg


#7

Hi All,

While running the explain plan for any query in the toad iam getting below
error. Could any one please help on this issue?

ORA-00980: synonym translation is no longer valid

Regards,

Venkat


#8

Morning Venkat,

While running the explain plan for any query in the toad iam
getting below error. Could any one please help on this issue?

ORA-00980: synonym translation is no longer valid

it sounds remarkably like a table (or other object) referred to using a
synonym has been dropped or altered in such a way as to make the synonym
invalid.

For example :

create synonym fred for norman.fred;

will be ok as long as no-one drops table norman.fred. If they do, the
synonym remains but is no longer valid as the object it refers to, is no
more.

HTH

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#9

Sorry, clicked SEND too soon!

While running the explain plan for any query in the toad iam
getting below error. Could any one please help on this issue?
ORA-00980: synonym translation is no longer valid

it is equally possible that the PLAN_TABE (usually owned by SYS) has a
synonym (PLAN_TABLE?) and the sys.plan_table has gone away.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk