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!
Hi - I should have mentioned that a co-worker installed it on his machine - also XP - and it worked fine. We both have newly installed laptops from our company so I would expect the configurations are the same, but perhaps I should call deskside support.
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 Dan - thank you for the suggestions. I checked them and the casing is correct & the movie is in the same folder as my page. I am wondering - I read so much about compressing the file and 'getting it ready for the web page', if that is actually somewhat of a requirement? I was...
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...
HI - thanks for your response. We use Crystal 8.5 & I'm referring to the database fields. The particular fields used to show up & all of a sudden they do not (just a few of them). We don't have MS Access so we can't try that, but the same thing occurs with Actuate. They are string fields -...
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 Pascal - thank you for the information. I had not thought of doing a routine like that. Is that in VB? I don't have visual basic on my work machine, but perhaps I can do something like that from within Excel VB code. I hadn't thought of that. I ended up being able to use the Excel...
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.