Wrapping oracle pl/sql code in Oracle Database

wrapping oracle pl/sql code;
Go to the command prompt and execute like this....
C:\>wrap iname=procedure_name.sql to oname=procudure_name.olb

Exporting in 11G database

Allocate extent for alter table

SELECT 'ALTER TABLE '||table_name||' ALLOCATE EXTENT;' FROM user_tables WHERE segment_created = 'NO';

Killing Locked Session in oracle database.

----------------query---------------
SELECT
    O.OBJECT_NAME,
    S.SID,
    S.SERIAL#,
    P.SPID,
    S.PROGRAM,
    SQ.SQL_FULLTEXT,
    S.LOGON_TIME
FROM
    V$LOCKED_OBJECT L,
    DBA_OBJECTS O,
    V$SESSION S,
    V$PROCESS P,
    V$SQL SQ
WHERE
    L.OBJECT_ID = O.OBJECT_ID
    AND L.SESSION_ID = S.SID
    AND S.PADDR = P.ADDR
    AND S.SQL_ADDRESS = SQ.ADDRESS;

-------------------Execute Script---------------------

BEGIN
FOR C IN (SELECT S.SID SID, S.SERIAL# SERIAL FROM V$LOCKED_OBJECT L, V$SESSION S WHERE L.SESSION_ID = S.SID) LOOP
   EXECUTE IMMEDIATE ('ALTER SYSTEM KILL SESSION ''' || C.SID || ',' || C.SERIAL || '''');
END LOOP;
END;


 ------------------killing connected session-------------------
DECLARE
   lc_username   VARCHAR2 (32) := 'USER_NAME';
BEGIN
   FOR ln_cur IN (SELECT sid, serial# FROM v$session WHERE username = lc_username)
   LOOP
      EXECUTE IMMEDIATE ('ALTER SYSTEM KILL SESSION ''' || ln_cur.sid || ',' || ln_cur.serial# || ''' IMMEDIATE');
   END LOOP;
END;
/

REP-56055 exceeded max connections allowed Oracle Reports Error

Oracle Forms -REP-56055 exceeded max connections allowed Oracle Reports Error

If you encounter the error, REP-56055 exceeded max connections allowed Oracle Reports Error then you need to increased the number of database connection in the reports configuration file.



1. Goto $ORACLE_HOME/reports/conf/ , find your server report name e.g. TestReport.conf

2. find the connection maxConnect="20" and set it to a higher values.

3. Restart the reports services .

Using Bangla(Unicode) In Oracle Database.

Using Bangla(Unicode) In Oracle Database.
SQL> conn /as sysdba
Connected.
SQL>
SQL>
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP RESTRICT;
ORACLE instance started.

Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 402654632 bytes
Database Buffers 369098752 bytes
Redo Buffers 5259264 bytes
Database mounted.
Database opened.
SQL> ALTER DATABASE CHARACTER SET AL32UTF8;
Database altered.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP;
ORACLE instance started.
Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 402654632 bytes
Database Buffers 369098752 bytes
Redo Buffers 5259264 bytes
Database mounted.
Database opened.
Now Check Using Bangla Using Toad 10.5 and Avro Bangla keyboard.

Bangla Font Configuration With Oracle

Bangla Font Configuration With Oracle
First Collect SolaimanLipi.ttf (Click hear) Font from a Reliable Source.Install this font and follow below steps:
*** It will be better if u use Developer10g Rel-2 ( Version 10.1.2.0.2 - 32 Bit )
*** During database installation must be change Product Language by AL32UTF8
[Remember that, u must have configure JRE in Webutil Configuration
For JRE, must be include the following code into Formsweb.cfg file
(Path: DevHome\forms\server\)
###########################################################################
# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=/forms/java/jre-6u17-windows-i586-S.exe
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0016-0017-FFFF-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=/forms/java/jre-6u17-windows-i586-S.exe
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_17
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0
#######################################################################
In the Key Configuration of formsweb.cfg file
replace baseHTMLjinitiator=webutiljini.htm by baseHTMLJInitiator=webutiljpi.htm
archive=frmall.jar
webUtilArchive=frmwebutil.jar,jacob.jar
baseHTMLJInitiator=webutiljpi.htm
#######################################################################
For Download JRE(jre-6u17-windows-i586-s.exe)
Classid : CAFEEFAC-0016-0017-FFFF-ABCDEFFEDCBA ]
1. Start>>Run>>regedit>>Database Home>> Edit NLS_LANG file by double click
Replace AMERICAN_AMERICA.WE8MSWIN1252 by AMERICAN_AMERICA.UTF8
2. Start>>Run>>regedit>>DeveloperSuit Home>> Edit NLS_LANG file by docuble click
Replace AMERICAN_AMERICA.WE8MSWIN1252 by AMERICAN_AMERICA.UTF8
3. For showing in report go to the path
..\...\DevSuiteHome\tools\common\uifont.ali
Write "SolaimanLipi" = "SolaimanLipi.ttf"
between [ PDF:Embed ] and [ PDF Subset ]
4. Developmnent machine and for app
..\...\DevSuiteHome\forms\java\oracle\forms\registry.dat
Go to default.fontMap.appFontnames line and append SolaimanLipi font name by the following.
default.fontMap.appFontnames=SolaimanLipi,.....
If you want to show default font with SolaimanLipi.(Not Mandatory) then
Find the lines default.fontMap.defaultFontname=Dialog
and replace by default.fontMap.defaultFontname=SolaimanLipi
5. Shutdown OC4J Instance once then again Start OC4J Instance.
[N.B: 01. Use Avro Keyboard (version: avrokeyboard_4.1.0) and Install SolaimanLipi font into your operating system's FONTS folder.
02. Go Start Menu >> Settings >> Control Panel >> Regional & Language Options >>
Then Select Languages Tab and Check Install files for complex script & right-to-left languages(Including Thai)
>> Ok(You have need Operating Systems CD & your system must be restart.)]