LiveReports and PL/SQL 1

[oscript]

Has anyone got an example LiveReport that relies on a PL/SQL procedure or function that they could share ?

Many thanks.

 

[LenOlson]

The OT Knowledge Center has a discussion thread on LiveReports with quite a few examples posted --have you looked there?

 

[ggriffit]

The LiveReports discussion can be found at

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2249677&objAction=view&sort=name

but does require a login - ask you OT Account Manager or Livelink Admin for this.

At present using LiveReports with PL/SQL is not supported - see

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2244484&objAction=view&show=2

There are several threads that turn up when searching the Knowledge Center -

https://knowledge.opentext.com

for key words such as "PLSQL", "Stored Procedure" and "PL/SQL".

For SQL Server you can try the solution from

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2692051&objAction=view&show=2.

Although I've not tested it myself and the %1 etc are bind variables from the LiveReport definition.

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2786545&objAction=view&show=2

gives some more tips on SQL Server, but no definite info about Oracle.

From the wording in this posting

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2839590&objAction=view&show=2

it sounds like Oracle users are out of luck.

You could always create a server side script such as an ASP/Perl/PHP file that connects to the DB and runs the Stored Procedure for you and then returns the results in the same style as a LiveReport. However, this would be more difficult if you needed to filter on permissions for example.

Does anyone else have any suggestions ?

 

[davegee]

Don't know much about oscript, but I do know about pl/sql (sounds like a techie version of "What a Wonderful World it Would Be").

If you write a stored function in pl/sql, you can then use it in your straight SQL. Eg a function called Get_Age(My_Birthday) would be used in SQL like this...

select Get_Age('01-01-1994')
from dual;

...would retrieve the number 21 (I wish). This works in SQL*Plus, which is very primitive, so it should work from oscript. Try it with something simple.

 

[VOLFONI]

daveggee is right : Indeed you can call functions in a Livereport with oracle
You can also pass parameters....