Home » Infrastructure » Windows » How to insert CRLF in stored procedure using OraOleDb
How to insert CRLF in stored procedure using OraOleDb [message #100350] Mon, 04 November 2002 02:21 Go to next message
Ananth HR
Messages: 1
Registered: November 2002
Junior Member
Hi,

I am using OraOleDb provider to connect to Oracle. I am trying to create a stored procedure using OleDb control in Delphi using TADOQuery. Stored Procedure gets created, but when I query the source from Oracle (user_source table), I see only one row has been created, though the text was formatted with carriage return and line feed (CRLF). Ideally what should have happened is that there must have been multiple rows in user_source for that procedure.
Does anyone know how to insert CRLF while creating stored procedure using OraOleDb?

Regards,
Ananth

Report message to a moderator

Re: How to insert CRLF in stored procedure using OraOleDb [message #100405 is a reply to message #100350] Thu, 12 December 2002 09:42 Go to previous message
Sreedhar
Messages: 30
Registered: March 2000
Member
I am also facing the same problem with ORAOLEDB. Can you please help me out if you get the solution..

Report message to a moderator

Previous Topic: Install ONLY SQL*Plus?
Next Topic: Installing / running Forms &Reports 6i with Oracle 9i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 08:22:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.