Recent content by Dagon

If you desperately wanted to use the Oracle 11 pivot function, you could do something like this: create table testdenorm (id number, path varchar2(100 char), security varchar2(50 char)); insert into testdenorm values ( 208...

Sorry, this got garbled. It was supposed to say this: I created a button in a form with a confirm dialog to allow the user to cancel the action using: <button> ... onclick="return confirm('Are you sure?')" </button> That works fine and the button action is cancelled if the user clicks...

That works fine and the button action is cancelled if the user clicks Cancel on the confirm box. But I really want it to be a bit more sophisticated and take parameters to determine whether it displays the dialog box or not. As a first step, I have a JS function such as: function...

Try changing IF :OLD.EVDATE >= 'SYSDATE' THEN to IF :OLD.EVDATE >= SYSDATE THEN

Yes, that's exactly what I would expect to appear.

Month" appears to pad the month name with spaces (presumably to the length of the longest month). Trimming it should fix the problem: create or replace trigger trigtest BEFORE INSERT OR UPDATE OF evdate ON event FOR EACH ROW BEGIN IF TRIM(TO_CHAR(:NEW.evdate,'MONTH')) = 'AUGUST' THEN...

You can use the "create schema" command to create multiple options in one session, but I don't think you can also include a drop table. I'm not entirely sure why it would be such a big deal, though.

BTW, even if you get round the problem of it not recognising your type, the code is completely wrong. You haven't initialized your objects or extended them to add new elements. I've put together an example to show you how you should use object types in PL/SQL. CREATE OR REPLACE TYPE...

All objects and packages, that is.

Are all the objects being created by the same user?

It's impossible to diagnose anything without more information here. What is the report doing? What is it written in? How are you populating the v_a return variable?

True, but you could easily combine it with the formula you already heave for excluding weekdays. Alternatively, you could populate the weekends into the table as well, which would be very easy to do using a query such as: select next_day(trunc(sysdate), 'Saturday')+(7*(level-1)) from dual...

As I suggested in my response to getjjb's duplicate posting, LTRIM could also be used. I think this would be better because the function would then work regardless of whether there was a leading comma or not.

That sounds quite reasonable because effectively you have an empty element at the start of your string. You could just trim off the leading ',' with something like: lv_str varchar2(50) := ltrim(p_in_string, ',');

How can U3L.DTK.DATE3 be a third table? Your other tablek is U3L.DTK.DATE2 and DATE2 is clearly the column name, so U3L must be schema and DTK must be the table name. One possibility would be to do something like this: create table end_dates (date2 date, id number); create table...