Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem creating a function with Visual Basic

Re: Problem creating a function with Visual Basic

From: michaela <michaela_at_img.mhs.compuserve.com>
Date: 1997/12/16
Message-ID: <6769dh$97u$1@nntp3.uunet.ca>#1/1

I don't know why this is happening. The way I would find out, though, is to read a good, working function's definition from the USER_SOURCE table into a string. Then do this:
for x = 1 to len(myfndef$)

    debug.print asc(mid$(myfndef$, x,1)); next x

Sylvan Creach wrote in message <66vs8q$q7a$1_at_news-2.csn.net>...
>Hi experts,
>
>This is a tough one. I'm using Visual Bacic 5.0 to create a function
>within Oracle. It works fine except the function is created within
>Oracle's all_source table as one line.
>
>I tried to add different linefeeds "VbCr chr(10)", "VbCrLF chr(10 & 13),
>and VbLineFeed within the SQL string without success.
>
>Anybody got any ideas?
>
>Thanks in advance,
>
>Sylvan Creach Oracle DBA
>Cobe Labs
>1185 Oak St.
>Lakewood CO, 80215
>
>Email: sylvan_at_cobe.com
>
>
Received on Tue Dec 16 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US