Resources

Random Errors

ORA-00154: protocol error in transaction monitor

Cause: The transaction monitor returned TMJOIN on an AX_REG call but the transaction was locally suspended.

Action: Contact the transaction monitor customer support.

Random Errors

ORA-00153: internal error in XA library

Cause: The XA library could not access thread-specific pointers.

Action: Contact customer support.


Designed by:
SiteGround web hosting Joomla Templates
LENGTH
Your Ad Here

ORACLE CHARACTER FUNCTIONS: LENGHT

In Oracle/PLSQL, the length function returns the length of the specified string.

SYNTAX:
result:= LENGTH ( input)

Data type:
char - CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, NCLOB
result - NUMBER


Modifications:
LENGTH, LENGTHB, LENGTHC, LENGTH2, LENGTH4

Applies To:
Oracle 8i, Oralce 9i, Oracle 10g, Oracle 11g

Length function example:

SELECT LENGTH('TEST') FROM DUAL;

Wynik
---------
4

 
 

Your Ad Here
Comments
Add New Search RSS
+/-
Write comment
Name:
Email:
 
Title:
UBBCode:
[b] [i] [u] [url] [quote] [code] [img] 
 
 
:angry::0:confused::cheer:B):evil::silly::dry::lol::kiss::D:pinch:
:(:shock::X:side::):P:unsure::woohoo::huh::whistle:;):s
 
Please input the anti-spam code that you can read in the image.

3.25 Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."

 

Random Errors

ORA-00155: cannot perform work outside of global transaction

Cause: The application tried to perform some work on either an Oracle 7.3 server or an Oracle8 server with local transactions disabled while outside of a global transaction.

Action: Check if the application is connected to an Oracle 7.3 server. The Transaction monitor must not return a NULL XID on an AX_REG call when the resource manager is Oracle 7.3. If the application is connected to an Oracle8 server, either set nolocal=f in the xa_open string or start a global transaction prior to attempting the work.

 

Resources

Oracle Database Support, Powered by Joomla! and designed by SiteGround web hosting