Home » SQL & PL/SQL » SQL & PL/SQL » QASPro Interface
QASPro Interface [message #204804] Wed, 22 November 2006 02:57 Go to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Does anyone out there have code to interface to QAS Pro V5 on Linux, from Oracle.

We've got a lovingly hand crafted DLL for the Windows version, and I drew the short straw and get to write one for the new Linux system.
Re: QASPro Interface [message #205158 is a reply to message #204804] Thu, 23 November 2006 09:56 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm not noticing a lot of activity on this one....
Re: QASPro Interface [message #208869 is a reply to message #205158] Tue, 12 December 2006 06:47 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Sorry, never heard of it...

MHE
Re: QASPro Interface [message #208878 is a reply to message #204804] Tue, 12 December 2006 07:14 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Hi,

I don't know if I can help, but we use QAS here. I don't know a lot about it but we have an Oracle package that calls the QAS stuff on AIX Unix?

I can let you know how we call it if that's any help?
Re: QASPro Interface [message #208882 is a reply to message #208878] Tue, 12 December 2006 07:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
That'd be fantastic if you could.
Re: QASPro Interface [message #208884 is a reply to message #204804] Tue, 12 December 2006 07:27 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Here's the open and close routines we use

-----------------------------------------------------------------------------
---- Function to wrap QAPro_Open
-----------------------------------------------------------------------------
  FUNCTION QAPro_Open
    (
     vs1 IN varchar2,
     vs2 IN varchar2
     )
     return pls_integer
    as language C
    library QAPUIEB
    name "QAPro_Open"
    parameters
    (
     vs1 string,
     vs2 string
     );
-----------------------------------------------------------------------------
---- Procedure to wrap QAPro_Close
-----------------------------------------------------------------------------
  PROCEDURE QAPro_Close
    as language C
    library QAPUIEB
    name "QAPro_Close";


These are called from the form
return_code := QAUPIEB_Wrap.QAPro_Open('/dir/dir/QAS/qaddress.ini','qadefault');

QAUPIEB_Wrap.QAPro_Close();
Re: QASPro Interface [message #208885 is a reply to message #208882] Tue, 12 December 2006 07:27 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

oops!

[Updated on: Tue, 12 December 2006 07:28]

Report message to a moderator

Re: QASPro Interface [message #208892 is a reply to message #208884] Tue, 12 December 2006 08:02 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Interesting.
It looks like you've created a package QAUPIEB_Wrap that contains a series of C calls directly into the QAS supplied library - am I on the right track here?

The system I've got to replace here has added an extra step into this process by creating our own Dll (we're on windows) that maps the QAS Apis onto a completely different set.
Re: QASPro Interface [message #208899 is a reply to message #204804] Tue, 12 December 2006 08:41 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Yeah that's what we seem to have, never had anything to do with it myself though.

Guess that's no good to you then?
Re: QASPro Interface [message #208905 is a reply to message #208899] Tue, 12 December 2006 09:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, it may be - up until now I'd had a huge blind spot that prevented me from seeing something - I'd been assuming I'd have to rewrite our wrapper for the new API (a bit of a problem, seeing as I don't do C coding) and then create a set of oracle interface functions to talk to our wrapper. I'd not thought that I could just write a set of interface functions straight to the QAS code.

It's amazing what someone elses point of view will do at times.

could you let me know how you map the C datatypes to Oracle ones (I see Varchar2 <=> string in your example)
Re: QASPro Interface [message #208907 is a reply to message #204804] Tue, 12 December 2006 09:38 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
From what I can tell we do

pls_integer to int
pls_integer to long

Thats the only ones (apart from varchar2 to string) that I can see in the package
Re: QASPro Interface [message #208912 is a reply to message #208907] Tue, 12 December 2006 09:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Thanks - I'll let you know how it goes.
Re: QASPro Interface [message #208954 is a reply to message #208912] Tue, 12 December 2006 12:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Funny, this thread has been sleeping for a couple of weeks.
Then someone comes along saying nothing but 'I don't know', and all of a sudden it's shaken to life! Smile
Re: QASPro Interface [message #208960 is a reply to message #208954] Tue, 12 December 2006 13:25 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Frank wrote on Tue, 12 December 2006 13:51
Funny, this thread has been sleeping for a couple of weeks.
Then someone comes along saying nothing but 'I don't know', and all of a sudden it's shaken to life! Smile


One thing I can think of is that it was the day before Thanksgiving in the USA where most of us have 4 days off (and maybe leave a little early the day before). Maybe people didn't see it initially and then on Monday, it was so far back in the list of messages, people missed it again.

I'll have to admit, I don't recall seeing it the first time, and when came back that Monday, there were so many messages in all the forums I check, that I only viewed the messages on the current page and didn't go back any further.
Re: QASPro Interface [message #209050 is a reply to message #208960] Wed, 13 December 2006 01:36 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Lucky for Mr. Rowbottom I had tons of unread threads. I "bumped" this thread back up when I encountered it Wink. I think it's only fair to try to help out a member that has helped so many others.

MHE

[Updated on: Wed, 13 December 2006 01:37]

Report message to a moderator

Re: QASPro Interface [message #209061 is a reply to message #209050] Wed, 13 December 2006 02:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Thanks for bumping it.
I've had this particular task lurking in my To-Do list for a while now, and hopefully it'll be less of a trauma now.
Re: QASPro Interface [message #221804 is a reply to message #209061] Wed, 28 February 2007 09:20 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Thanks again.
I've finally got to start this little project, and the interface works like a dream.
Previous Topic: Question about working with a "default" schema
Next Topic: Count function
Goto Forum:
  


Current Time: Fri Dec 09 21:22:19 CST 2016

Total time taken to generate the page: 0.06358 seconds