function returns results wrapped with breaking space.

[tomblanchard]

I am executing a function that returns a dynamically built query, however the results get wrapped with a breaking space. Is there some way that I can stop this?

For instance if my result is supposed to come back as:

SELECT dummy from dual;


It returns:

SELECT dum
my from dual;


With a breaking space between the two m's in dummy, causing my function that executes this to throw the error missing expression when executed in Sql*Plus.

Does anyone know of a workaround for this?

 

[tomblanchard]

nevermind have it working now.

I really appreciate everyones help in the last couple of days.

Thank you guys.

 

[SantaMufasa]

Tom,

To keep this thread and have it be of value to anyone who follows, you need to post a resolution. If you choose not to post the resolution, please Red-Flag your original post with the "Inappropriate post? If so, Red Flag it" button.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[tomblanchard]

You are correct:

execute immediate replace(sql_in,chr(13),'') into x;

 

[SantaMufasa]

Tom,

My curiosity: How is the EXECUTE IMMEDIATE code preferrable to/more functional than:

x := replace(sql_in,chr(13),'');

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.