It was ok....but..I have to deploy the application....
Is it easy to deploy the application without OEM??
After login OEM I am getting a blank page...Do u help me with any suggession....
User Profile
Collapse
-
Enterprise Manager is not responding
Hi,,,,
OEM of the application server is not responding after the logging process.....Plz help...its urgent...
We r using Oracle Enterprise Manager 10g Application Server Control 10.1.2.0.2 ......
If u need any further detail plz reply.. -
home instance down
hiii all
i am using oracle enterprise manager 10g for deployment of application.... but the problem i am facing is ..oc4j instance home is with status down..i tried starting it..but nothing is happening..may be because of some errors.but i am not able to find it out...can anyone help me to make the status of home instance alive????
thanks in advance -
column updation
hi,
I want to update a set of values in a column at a time inside a table. i.e.without using loop.So please suggest query to perform that operation.Now i am using loop.Increments the value onebye one and executing update query -
merging two tables
Hiiiiii
There are two tables having the same name in two schemas......
I want add some rows from one table to another........ ...
Please suggest a sql query to perform that operation...... .... -
-
max value from a string
In my table there is a column having values like
DC500
DC5001
..............
.......
.........
DC700
please suggest a query to select maximum value(ie DC700) from that column....... -
private void Details(String A,String B,String C,String D)
{
Clob tempClob = null;
try
{
con=DBConnectio n.getConnection ();
pstmt=con.prepa reStatement("IN SERT INTO TABLE values('','"+A+ "','',EMPTY_CLO B(),'"+B+"','"+ D+"','')");
tempClob = (Clob) oracle.sql.CLOB .createTemporar y(con,...Leave a comment:
-
con=DBConnectio n.getConnection ();
THIS IS THE STATEMENT FOR GETTING CONNECTION.
AND THE CONNECTION IS CLOSED ONLY AFTER THOSE STATEMENTS.Leave a comment:
-
-
THE EXCEPTION IS GETTING AFTER THE FOLLOWING LINE
oracle.sql.CLOB newClob =oracle.sql.CLO B.createTempora ry(con, false, oracle.sql.CLOB .DURATION_CALL) ;
AFTER THIS LINE,ST.CLOSE() IS EXCECUTED AND EXCEPTION IS DISPLAYEDLeave a comment:
-
-
CAN U TELL ME WAT IS WRONG WITH THE CODE.
THE CODE IS NOT EXECUTING
pstmt=con.prepa reStatement("IN SERT INTO TABLE values('','','' ,?,'','','')");
oracle.sql.CLOB newClob =oracle.sql.CLO B.createTempora ry(con, false, oracle.sql.CLOB .DURATION_CALL) ;
newClob.putStri ng(1,VALUE);
pstmt.setClob(4 , newClob);
int rowcnt = pstmt.executeUp date();
THANK...Leave a comment:
-
java.lang.ClassCastException
hi,
while i was trying to insert value into a blob column, i got an exception saying
java.lang.Class CastException: com.evermind.sq l.OrclResultSet -
I Got It While Searching In Google.
It Is To Store The String To Be Inserted Into Clob Column In A Temporary Clob. And This Can Be Inserted.
The Main Advantage Is That , By Using This, I Heard We Can Store Large No Of Characters Than Inserting DirectlyLeave a comment:
-
CAN ANYONE TELL ME THE USE OF THIS CODE?
import oracle.sql.CLOB ;
import java.sql.Connec tion;
import java.sql.SQLExc eption;
import java.io.Writer;
...
private CLOB getCLOB(String xmlData, Connection conn) throws SQLException{
CLOB tempClob = null;
try{
// If the temporary CLOB has not yet been created, create new
tempClob = CLOB.createTemp orary(conn,...Leave a comment:
-
hi good morning
it seems only less number of characters can be inserted directly into clob columb.
but, if we use a stored procedure to insert into clob more data can be inserted.
i am not aware of writing a stored procedure..
can anyone help me with a sample
thanks in advanceLeave a comment:
-
ok.
i will try and will let u know what is the problem, if i get
anyway,thanksLeave a comment:
-
but i have a doubt
i got the information from net than
Maximum length of CLOB (in bytes) is 2 147 483 647 and this is the same for blob also.
now the doubt comes
i am not able to insert data into clob, which i successfully uploaded using blob.
how can this happen if they have the same size limit?
thanks in advanceLeave a comment:
-
hi
atlast got the solution
i dint know that only upto 4000 characters can be saved as clob.
that was the problem.
when i gave less than the limit, a new row was inserted and i was able to retrieve the data as u said earlier
thanksLeave a comment:
No activity results to display
Show More
Leave a comment: