Search results for query: *

Thanks for you response Chip Technically no I did not contact them, for the tests I am doing I am "them". I am only doing a small part of the overall application. I do not know what site the end users will actually be connecting to. Its all about providing informative and meaningful...

I have been tasked to programmatically determine what certificate a webservice is looking for. The site does have a web page to connect to. When connecting to that web page a dialog box pops up, "Choose a digital certificate", with some of the certificates from the personal store to choose...

Thank you. I have recently come to this realization as well. I read the documentation to mean that the report was submitted to the queue and then reutrns. In actuality it submits it as a new job and the response waits for the report to be completely processed. This is not a desired effect...

First, thank you for your response. Actually I am submitting the report over the URL, so I guess that would be on the WEB. Here is the skinny: I need to submit a report to be generated in a trigger, so that when a table is updated the report is generated. Once the report is generated I need to...

I am submitting jobs to the Report Server to generate a report. This is working fine. However, some the reports can take a while. I would like to be able to check on whether or not the report has finished. I can use the showjobs "function" and get a list of all the jobs with their Job Id and...

Well I figured it out myself. Apparently I forgot to include the parameter "userid=scott/tiger@orcl", I thought "user" was handling that but apparently not. Also just to let others know: Using a keymap in the CGIcmd.dat file can hold all the parameters that are static, I just then include the...

How to get around Report Server Logon page? I am trying to kick off a report in a trigger. I cannot use the event driven publishing, due to OS versions. So, I am trying to submit a job using UTL_HTTP. The report server has been setup to accept a job through a web page, I tested it and it...

Yea he can be a bit of a pain sometimes. I love your work around. I will try it out and let you know how it goes. I am thinking about making the process on the remote machine a stored procedure that I would call from the Main Db machine, and just pass the name of the file to read in. You see...

Thank you for posting, yes they are both on Unix platforms. I talked to the Admin, but he started ranting about securtity issues and laughing. I did not get all of it, but something about the headquarters not allowing it. What are the security issues for sharing a folder from one unix machine...

The short of it. Currently we are running an oracle 8i(8.1.7) database on one machine(222.222.222.001) oracle report server on a second macine(222.222.222.002). When the report server generates a report it gets saved to /tmp/reports on the second machine. Which works great so that they can be...

Ok, Here is what I am trying to do: I have Java app that is being called through an Oracle stored procedure wrapper CREATE OR REPLACE FUNCTION TEST_STR( ARG IN VARCHAR2 ) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'testapp.longstring(java.lang.String) return java.lang.String'; now this app simply...

you should be able to get the date using SYSDATE. You can format it by doing: to_char(SYSDATE,'DDMMYYYY') which is 19042004 to_char(SYSDATE,'DDMONYYYY') which is 19APR2004 for example SELECT 'Y:\Back_UP\Letters\letterout'|| to_char(SYSDATE,'DDMMYYYY') ||'.txt' INTO letterout_name from...

Try this, it is a WAG but seems to work on a limmited basis, but I have no Idea how any of your data is being used. I cannot think of a good way to do this. select o.ordno, o.custid, nvl(ch.def_qty,50) from orders o, customer c, channel ch where o.custid = c.custid and o.warehouse =...

Yikes straight plain sql. I am not sure. Are you going against an oracle DB, are you just not able to do stored procedures, or no PL/SQL at all. Oracle can do some PL/SQL inside a select statement. Can you use the DECODE() function. It would be messy depending on the size of your field...

Very odd. That is what they are for. Are you sure the spaces you are seeing are in the field, and not from the way it is being displayed? Not trying to be rude/mean, just first I have heard trim() not working. You could write a stored procedure to trim undesired characters from the field...

I think Oracle has trim functions. TRIM(field_to_trim) <-- trim spaces from both sides LTRIM(field_to_trim) <-- trim spaces from left side RTRIM(field_to_trim) <-- trim spaces from right side Randall2nd Ignorance does not equal stupidity, do not treat it as such.

Thank you for your insight. I do not need DB independance, and do not need to worry about non-Oracle DBs. The DB will be Oracle(8i for now, 10g in the undetermined future). Oracle Licenses are not an issue either. I am pretty sure we have ALL of them. I agree about the DB vs application...

The short of it: I need to take data from an Oracle 8i database and create an XML document on a Unix OS. What is the best way (apps, language, process, etc...) to do this? The long of it: There is a debate about what the best way to get data from the Oracle 8.1.74 database into an XML format...

try something like this: /// <summary> /// submits an xml set as an array of bytes, to a servlet paraser /// </summary> /// <param name="uri">full URL of the parser</param> /// <param name="xml">string containing a Xml document</param> /// <param name="usr">User...

Not sure if you have solved this or not, if so please post the code that fixed this problem. I think the problem you are running into is that you are not traversing the XPath correctly. When you use MoveToNext it tries to go to the next same level node of <PageContent>, I am guessing that you...