00:36:02 <loggy> loggy has joined #openacs
00:36:02 <forward.openprojects.net> topic is: Welcome to the OpenACS helpline http://openacs.org
00:36:02 <forward.openprojects.net> Users on #openacs: loggy davb zzzirk chump strainmaker rbm abbaJ AaronSw shagster andyn GEM 
00:36:02 <ChanServ> This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
00:36:43 <davb> Good question. I haven't learned in depth yet. Check out the w3c.org pages. 
00:37:19 <davb> http://www.xmlhack.com
00:37:19 <chump> B: http://www.xmlhack.com from davb
00:37:26 <davb> B:|XMLhack.com
00:37:26 <chump> titled item B
00:37:35 <davb> B: XML news and links to XML resources
00:37:35 <chump> commented item B
00:51:23 <davb> brb
00:51:24 <davb> davb has quit
02:57:19 <gilbertw> gilbertw has joined #openacs
03:48:52 <davb> davb has joined #openacs
03:55:17 <gilbertw> gilbertw has quit
03:55:25 <ChanServ> ChanServ has changed the topic to: Welcome to the OpenACS Helpline | http://www.openacs.org/
03:55:36 <ChanServ> This channel is logged: http://www.blogspace.com/openacs/chatlogs/ and blogged: http://www.thedesignexperience.org/openacs/ircblog
03:55:38 <gilbertw> gilbertw has joined #openacs
03:55:38 <gilbertw> gilbertw has left #openacs
04:05:00 <davb> davb has quit
04:39:50 <gilbertw> gilbertw has joined #openacs
05:11:14 <gilbertw> gilbertw has quit
06:44:48 <djg> djg has joined #openacs
06:58:00 <PascalS> PascalS has joined #openacs
06:58:09 <PascalS> mornin!
08:22:23 <til> til has joined #openacs
09:13:26 <ola> ola has joined #openacs
09:17:44 <ola> ola has quit
09:17:48 <ola> ola has joined #openacs
09:54:37 <til> til has quit
10:57:10 <til> til has joined #openacs
11:37:55 <davb> davb has joined #openacs
11:49:58 <davb> davb has quit
12:03:29 <til> a quick oracle q: i want to call a function but i am not interested in the return value (e.g. no variable to put the value in) - what's the syntax for that?
12:22:43 <davb> davb has joined #openacs
13:02:30 <strainmaker> why not just "select func() from dual" ?
13:05:01 <til> that gave me "PLS-00428: an INTO clause is expected in this SELECT statement"
13:05:16 <til> so i did "select func() into dummy from dual"
13:07:11 <til> is that the recommended way to do this? its a bit annoying that the dummy variable has to be declared
13:19:16 <davb> I don't think that's necessary?
13:19:32 <davb> You are trying to get the value of a function?
13:20:12 <til> no, i just want to call the function but i am not interested in the return value
13:20:22 <davb> In Oracle?
13:20:26 <til> yes
13:20:59 <til> inside a package, that is
13:21:15 <davb> Inside a PL/SQL procedure?
13:21:19 <til> yes
13:21:29 <davb> I think you can just call it like this func();
13:21:39 <davb> Maybe you don't need the ;
13:21:46 <davb> you don't need a select in oracle.
13:21:56 <djg> afaik that doesnt work in oracle
13:22:03 <djg> but just ignore the return vale?
13:22:45 <davb> You are calling a function that returns a value, but you don't need the value?
13:24:41 <davb> how about v_dummy_variable := function();
13:25:17 <davb> Here is how to call a procedure that does not return a value:
13:25:18 <davb> acs_permission.grant_permission(
13:25:18 <davb>   644 |  object_id => folder_row.folder_id,
13:25:18 <davb>   645 |  grantee_id => static_page.grant_permission.grantee_id,
13:25:18 <davb>   646 |  privilege => static_page.grant_permission.privilege
13:25:18 <davb>   647 |  );
13:25:25 <davb> ick.. sorry
13:25:39 <davb> acs_permission.grant_permission(values);
13:26:28 <til> but grant_permission is a procedure, not a function i guess?
13:26:53 <til> when i just called func(); it gave me a "PLS-00221: 'ADD_CONTENT' is not a procedure or is undefined"
13:27:12 <til> add_content is the name of the function
13:33:52 <til> til has quit
13:34:13 <til> til has joined #openacs
13:42:58 <AaronSw> AaronSw has quit
13:48:45 <davb> til. you need to call it like this packagename.add_content
13:54:39 <davb> I have no idea what I am doing, I am just copying from the openacs source.
14:00:07 <til> i tried it like this but i am getting the compilation error above ... but i have a terrible suspicion - maybe it was all my fault and i did not recreate the package that i am calling (i'll just reinstall and then ask again if still necessary)
14:04:07 <markd> markd has joined #openacs
14:23:42 <davb> Hi markd!
14:24:31 <davb> good luck til
14:25:10 <til> thanx davb ...
14:38:10 <markd> hiya
14:38:16 <markd> what's til up to?
14:40:14 <til> i was wondering how to call a function from within oracle plsql when i am not interested in the return value (without putting it in a dummy variable)
14:40:55 <til> doing func(params); returned a compilation error ... but i suspect there's something wrong with my installation so i am reinstalling now
14:42:04 <rbm> select func() from dual;
14:42:25 <rbm> you need the "from dual" in Oracle.
14:43:03 <til> rbm: tried that and oracle said: "PLS-00428: an INTO clause is expected in this SELECT statement"
14:45:44 <markd> can you write a procedure that calls the function, does the assigning to a variable?  and then not do anything with the reply
14:46:15 <markd> might be easier than trying to contort some sql to drop the return value
14:47:03 <markd> (and if your'e needing to drop the return value, then it may make sense to re-code the function in question to not return a value)
14:50:13 <til> ok, i will suggest that to vinod who wrote the acs-mail package with the function that i want to call
14:50:29 <til> is it possible to overload a function with a procedure in oracle?
14:51:13 <til> it's only cosmetic though, nothing stops me from doing a select func() into dummy from dual;
14:52:26 <markd> hmmm.. dunno about the overloading
14:52:29 <markd> it might work
14:53:34 <ola> ola has quit
14:55:18 <ola> ola has joined #openacs
15:00:10 <rbm> til: oh
15:02:45 <markd> markd has quit
15:06:16 <markd> markd has joined #openacs
15:07:21 <til> til has quit
15:07:39 <til> til has joined #openacs
15:10:35 <til> still doesn't work after reinstall. seems a function must be called like "select func() into v_dummy from dual;"
15:32:44 <PascalS> PascalS has quit
15:43:32 <djg> y
15:44:12 <rbm> z
15:44:52 <djg> hmm tzpical tzpos if zou have to switch kezboards often ;)
15:48:43 <markd> heh
15:48:54 <matto> matto has joined #openacs
15:49:03 <matto> matto has left #openacs
15:49:08 <markd> SuSE 7.1's installer has a problem - no matter what you choose as the keyboard type during installation, it uses a german layout upon first boot,
16:25:32 <andyn> andyn has quit
16:32:16 <andyn> andyn has joined #openacs
16:37:19 <markd> markd has quit
17:06:11 <Psychephylax> Psychephylax has joined #openacs
17:06:26 <Psychephylax> * Psychephylax begins writing his proposal
17:38:04 <markd> markd has joined #openacs
17:53:37 <markd> markd is now known as markd2
17:53:42 <markd2> markd2 is now known as markd
17:53:55 <markd> markd has quit
17:53:55 <til> til has quit
18:09:31 <Psychephylax> Psychephylax has quit
18:19:28 <AaronSw> AaronSw has joined #openacs
18:24:18 <GEM> http://allbusiness.findlaw.com/agreements/handspring/softwarelic.html
18:24:19 <chump> A: http://allbusiness.findlaw.com/agreements/handspring/softwarelic.html from GEM
18:39:02 <markd> markd has joined #openacs
18:43:24 <strainmaker> strainmaker has quit
18:46:03 <markd> markd is now known as d34thl0rD
18:46:27 <d34thl0rD> * d34thl0rD is L33t
18:46:30 <d34thl0rD> d34thl0rD is now known as markd
19:16:56 <GEM> a:Palm OS licensing agreement
19:17:35 <GEM> A: Palm OS licensing agreement
19:17:36 <chump> commented item A
19:50:26 <vinod> vinod has joined #openacs
20:07:50 <markd> hey Vinod
20:08:20 <vinod> hey mark! what's new?
20:08:54 <markd> not much
20:09:02 <markd> came back from a friend's wedding yesterday
20:09:03 <markd> down in Virginia
20:10:05 <vinod> cool! where in VA?
20:10:11 <markd> Fairfax
20:10:42 <markd> drove down saturday morning, headed back sunday
20:10:45 <vinod> nice. one of my best friends lives there. i just visited him a month ago
20:10:52 <vinod> how long of a drive is that?
20:11:33 <markd> cool
20:11:39 <markd> about 4 1/2 hours
20:11:46 <markd> sometimes just 4 depending on how fast we go
20:13:01 <vinod> not too bad. i took the bus down from here to visit him and it took 10 hrs (with stops)
20:13:09 <vinod> won't do that again!
21:11:52 <vinod> vinod has quit
22:18:39 <markd> markd has quit
22:38:22 <ola> ola has quit
23:29:43 <davb> davb has quit
23:49:43 <til> til has joined #openacs