Hi,
I am running some oracle DDL statements using an ADO command. The problem I am having is that the command text is formatted nicely, including CRLF for new lines. However when the object is created in the database all the CRLF's have disappeared and the object source is all on one line!
This is causing problems when I try to run sql to build, say a package that has some comments in it, not to mention it doesn't look very pretty!
Does anyone know why this is happening or if there is some escape sequence I can use to make sure they get through?
Matt
If you can keep your head while those around you are losing theirs, you obviously haven't grasped the seriousness of the situation
I am running some oracle DDL statements using an ADO command. The problem I am having is that the command text is formatted nicely, including CRLF for new lines. However when the object is created in the database all the CRLF's have disappeared and the object source is all on one line!
This is causing problems when I try to run sql to build, say a package that has some comments in it, not to mention it doesn't look very pretty!
Does anyone know why this is happening or if there is some escape sequence I can use to make sure they get through?
Matt
If you can keep your head while those around you are losing theirs, you obviously haven't grasped the seriousness of the situation
