Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding a column in a procedure

Re: Adding a column in a procedure

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 10 Jun 2002 12:47:05 +0100
Message-ID: <3d0491b9$0$8510$ed9e5944@reading.news.pipex.net>


Almost certainly something does happen, namely an error which you throw away.

Having said that modifying a table definition in a stored procedure is a truly dreadful idea. If you possibly can avoid it do so. If you can't think again I bet you can.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Steffen Pelzetter" <Steffen.Pelzetter_at_nexans.com> wrote in message
news:1023701467.819951_at_slbhw0...

> Hello,
>
> I want dynamicly add a column to a table in a stored procedur.
> The code I created id accepted by the compiler, but if I call this nothing
> happens.
>
> here is my code:
> AS
>
> cursor_name INTEGER;
>
> newcol varchar2(10);
>
> rows_processed INTEGER;
>
> BEGIN
>
> newcol:= 'TEST1';
>
> --to_char(sysdate,'DDMMYY');
>
> cursor_name := dbms_sql.open_cursor;
>
> dbms_sql.parse(cursor_name, 'alter table tablegrown add :X number(10)',
>
> dbms_sql.v7);
>
> dbms_output.put_line(newcol);
>
> dbms_sql.bind_variable(cursor_name, ':X',newcol,10);
>
> dbms_output.put_line('alter table tablegrown add :X number(10)');
>
>
>
> rows_processed := dbms_sql.execute(cursor_name);
>
> dbms_sql.close_cursor(cursor_name);
>
> EXCEPTION
>
> WHEN OTHERS THEN
>
> dbms_sql.close_cursor(cursor_name);
>
> END;
>
>
> What's wrong with that program?
> Please help.
>
> Steffen
>
>
>
>
Received on Mon Jun 10 2002 - 06:47:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US