Re: PL/SQL problem? Line too long?

Simon Mercer wrote:
>
> I have a number of PL/SQL procedures which insert data into tables,
> doing some 'housekeeping' along the way. This works fine, all you need
> to do for an insert, for example, is call the procedure like this;
>
> exec insert_test('field1','field2','field3');
>
> But now I have encountered the problem that there appears to be a
> maximum length for the line, and I have not found a way around this.
> PL/SQL interprets returns as the end of the command, and backslashes
> have no effect.
>
> Is there any way to extend this line, ideally to thousands of
> characters? (the limit now seems to be 255).
>
> Many thanks for your answers,
>
> Simon
>
> --
> Dr. Simon Mercer
> Ressourcenzentrum des Deutschen Genomprojekts
> +49 30 326 39111 (fax)
> mailto:mercer_at_rzpd.de

If I understand you correctly, you pass your arguments to the procedures as literals
(e.g. 'This is text' for text string or 12345000 for number) and line in witch you are calling procedure smetimes gets too long because of this long literals.

If you are calling procedure from PL/SQL, why don't you assign this arguments to predeclared variables and then pass just the names of variables? BTW, also the program code is much easier to read and mantain this way.

If you are calling the procedure from SQL*Plus, you can do the same thing with substitution variables.

Regards, Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================