pl/sql qestion [message #35774] |
Mon, 15 October 2001 06:40 |
sanjib rout
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
how to increase the size of a cursor in oracle through pl/sql programming and how to drop any column from a table. i create a cursor which display a certain amount of data the give the error message
message : buffer overflow 2000 bytes
----------------------------------------------------------------------
|
|
|
Re: pl/sql qestion [message #35776 is a reply to message #35774] |
Mon, 15 October 2001 08:03 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
buffer overflow error is not due to cursor. Do you have any dbms_output.put_line statements in your program?.
run following stmt
set serveroutput on size 100000
alter table to drop column.
alter table tablename drop column colname;
SURESH
----------------------------------------------------------------------
|
|
|
Re: pl/sql qestion [message #35785 is a reply to message #35774] |
Mon, 15 October 2001 22:48 |
akkiraju kiran kumar
Messages: 6 Registered: October 2001
|
Junior Member |
|
|
hi suresh,
To increase the buffer size use
dbms_output.enable(1000000);
this statement is first statement in your code.
next question i am not clear that yr asking a column of object in 8i concepts or from ordinary table.
if this from ordinary table there is no specific syntax for to delete a column. But u can do another way.
create a table with required columns
drop old table
rename new table to old table
if it is related to 8i objects refer the syntax given on oracle 8i documentation
kiran
----------------------------------------------------------------------
|
|
|
Re: pl/sql qestion [message #35811 is a reply to message #35774] |
Tue, 16 October 2001 23:22 |
Muruganantham
Messages: 1 Registered: October 2001
|
Junior Member |
|
|
hai sanjib,
To drop a column , give the follwing command in sql prompt ,It will work only in oracle8i.
alter table
drop column <column_name>;
If you are having only one column it won't allow to drop.
If the column having any master detail realtionship it won't allow.
Cursors:
If you have been used the cursor in infinte loop,there may be chance for buffer overflow.
So pls check your program.
Regards,
Muruganantham.
----------------------------------------------------------------------
|
|
|