' in dynamic sql

From: Allan Martin <allan.martin_at_saic.com>
Date: Thu, 6 Dec 2001 14:56:40 -0000
Message-ID: <3c0f16aa_at_cpns1.saic.com>

Hi,

[Quoted] [Quoted] I have got a dynamic SQL statement which when build, the data which is going [Quoted] to be inserted into a table, may have the ' symbol in it. This means that [Quoted] [Quoted] when I'm executing my SQL statement, the string is ended by the rouge ' . Can anyone suggest anything?

Allan Received on Thu Dec 06 2001 - 15:56:40 CET

This message: [ Message body ]
Next message: Nuno Souto: "Re: ' in dynamic sql"
Previous message: Joost Bataille: "Re: Report Background Engine Still will not close!"
Next in thread: Nuno Souto: "Re: ' in dynamic sql"
Reply: Nuno Souto: "Re: ' in dynamic sql"
Reply: Allan Martin: "Re: ' in dynamic sql"
Reply: Thomas Kyte: "Re: ' in dynamic sql"
Reply: gti_matt: "Re: ' in dynamic sql"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message