Hello - we have a function written in pl/sql. This function will either be called by another pl/sql procedure, or it may be called by an oracle form (6i). Is there anyway, while I am in the function, to tell who/what is calling it? We'd like the error handling to perform differently if it was...
Hello - I would like to write the following case statement using PL/SQL. Is it possible?
Case v_code
when in ('SIT','MOV','TST') then....
I can resort to
Case
when v_code in ('SIT','MOV','TST') then.... , but I thought the 1st option would be cleaner if there is a way to do it. Thanks!
Hello - has anyone run into this while running a crystal report? It only happens on particular machines. We are using Crystal Reports 6, pulling data from Oracle. The error is Bad Return Code 20515. Let me know if you need anymore info to clarify. Thanks!
Hello - I am attempting to install Crystal 6 locally off of a CD. When we get to the spot for choosing where to install we get the error 'Directory entry is not a valid directory name' . It doesnt' matter what directory we pick. Crystal has an article in their knowledge base on this, but it...
Hello - we use Crystal 8.5, connecting to db2. A new view was created that we cannot see. We can query it through db2 command center so we know we have access to it. But it does not show up in the crystal table list. We tried an F5 that someone suggested for a refresh. There is a setting in...
Hello - I want to post quicktime movies on my site that I save to my pc from my digital camera. I have researched how to embed the quicktime player on the page & how to put just a link on the page that launches quicktime and I am never successful. I can view quicktime movies on my laptop so I...
Hello - we use Crystal reports (& Actuate) to connect to db2 via ODBC. My coworker suddenly is missing some fields in the field list. If he connects via db2 server, he can see them all. Our company pushes a lot of automatic updates to our machines so we were wondering if one of those could...
Hello - I have to pull data from a Notes DB into Excel. I have Crystal Rpts, which I can use for the pull, but when exporting to Excel it only exports up to 255 characters. So I'm looking for a more direct route to connecting to the Notes database & getting a subset of the data into Excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.