[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1151
  • Last Modified:

Oracle forms cast OleVar to Varchar2

Hi,

I'm working with Oracle form 6i and I have a ActiveX
control on a form that has a property that I need to
read into a Varchar2 but the AxtiveX property is a OleVar.
How can I cast the OleVar to VarChar? I was looking at
the OLE2.Get_Char_Property, but I not sure if I'm using it
right, Then I tried the VBX.Get_Property, but I get error
FRM-41318 Item <myActiveX> is not a VBX item.

Thanks in advance.

Bill.
0
bnemmers
Asked:
bnemmers
1 Solution
 
vanmeerendonkCommented:
try using the build in
VAR_TO_CHAR  
  (actually, there are also VAR_TO_NUMBER & VAR_TO_OBJ)

l_varchar := VAR_TO_CHAR(l_olevar);

I don't know if l_varchar2 has spaces concatenated, but you'll find out,
0
 
bnemmersAuthor Commented:
I had to revamp my form and I didn't need this type of
conversion. So I don't know if it work or not, but thanks
for your time.

Bill :-)
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now