Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. goaway1234

    Session independant threads.

    The answer to your question is yes, but such a thread isn't really very reliable. You can take a look at http://msdn2.microsoft.com/en-us/library/system.threading.thread.aspx for an example of how to start it. A thread started like that will not be associated with any ASP session, and it will...
  2. goaway1234

    XSLT: storing enumerated values in variables

    I am relatively new to XSLT, so i hope this isn't too noobish. The task at hand is creating a web page where the result of some transform is displayed in a table, which has column headers that users can click to sort it. What I have is currently working, and for simplicity I removed all but...
  3. goaway1234

    favor to ask: wshmeta.xsd

    I am looking for an updated xml schema file of *.wsf files. I have been using the one that shipped w/ VS.NET 2003 but it is no longer current. Is there anybody who has VS.NET 2005 who could send me the updated schema document? I use a schema aware xml editor and having an updated copy would...
  4. goaway1234

    patterns and object orientation in classic asp?!

    I am a programmer on a rather large, old, and ugly asp web application, which uses oracle, msxml, and ado. This is a 'project in crisis' as it has become extremely difficult to maintain. Much of it is spaghetti code, and its original developers had no idea what the word 'modular' means. And...
  5. goaway1234

    get the full path of a the currently executing script

    ...to include the file path of the updaate script. Does anybody know whether it is possible to write a function that will return the path of the currently executing file (if any). The goal is that if in sql*plus, the user types @ C:\scripts\XXX.sql then the function returns 'c:\scripts\XXX.sql'.
  6. goaway1234

    help with oracle xml api for pl/sql

    a user in another forum told me that in 9i you can find this in the dbms_xslprocessor package. Thanks, Sem, for all your advice.
  7. goaway1234

    help with oracle xml api for pl/sql

    That would be perfect, except that it doesn't exist on 9i. When I try to call it, I get a 'invalid identifier' error. Is this something that our DBA must setup?
  8. goaway1234

    help with oracle xml api for pl/sql

    I think that it would. What I need is functionality that I've seen in every DOM implementation I've ever used; I'm just having trouble finding it in dbms_dom. Exactly what procedure in this package allows you to evaluate xpath expressions?
  9. goaway1234

    help with oracle xml api for pl/sql

    I'm new oracle's xml capabilities, and I'm having trouble making sense of the mountains of reference material available. I've had success with a couple of very ugly attempts, but I'm sure that I'm making this much more complicated than it needs to be. My procedure is given an xmltype such as...
  10. goaway1234

    ODP.NET: PLS-00707 with xmltype input parameter

    Well, I did finally have some luck using CLOBs. If CLOBs have OIDs, then perhaps the theory is wrong. I was able to create an OracleClob in .NET and pass it to an sp with no problems. I'm still not sure what the problem was, but it is a whole lot easier to put something like "xml_value :=...
  11. goaway1234

    advice needed: oracle data provider and xmltype

    I am developing an application that uses ODP with 9i release 2, and I'm having trouble creating xmltype input parameters. I posted a detailed description of the problem here The problem I'm having is specific to 9i; doesn't happen when connecting to a 10g database. Does anybody have...
  12. goaway1234

    ODP.NET: PLS-00707 with xmltype input parameter

    Thank you very much for your help--this problem has been frustrating me for the entire day. I tried a workaround. I create a function that returns an xmltype that always contains the document <xml/>. In .NET, I call this function and get the resulting OracleXmlType object, then use the Update...
  13. goaway1234

    ODP.NET: PLS-00707 with xmltype input parameter

    I have a web application where a web service written in C# coordinates communication between an Oracle 9i release 2 database and the rest of the application. In a method that is used to call store procedures, I am trying to add the ability to create xmltype input parameters. Everything works...
  14. goaway1234

    cursor not returning same rows as equivalent query

    yes, well thank you for all the lovely banter, but the rowcount statement was just something i threw in there for demonstration. I didn't consider the 15 lines in between opening the cursor and the put_line relevant. The cursor doesn't return any rows even when I check the rowcount after...
  15. goaway1234

    cursor not returning same rows as equivalent query

    yup
  16. goaway1234

    cursor not returning same rows as equivalent query

    unfortunately i get the same results when using the schema prefix.
  17. goaway1234

    cursor not returning same rows as equivalent query

    Yes, this is how i'm sure of what those values are. I've tried opening the cursor in a number of ways, and it always fails to return any rows. Below is the current code that I'm using to open the cursor in the inner loop: open new_child_orgs(l_child.id); dbms_output.put_line('child id ' ||...
  18. goaway1234

    Retrieve Blob/Memo text fields using MS Access

    ...convert that byte array into a string. A simple example: Public Sub Foo() Dim rst As New ADODB.Recordset Dim b() As Byte rst.Open "select * from doj_nd_test;",_ CurrentProject.AccessConnection b = rst("mytext").GetChunk(16) Debug.Print ByteArrayToString(b)...
  19. goaway1234

    cursor not returning same rows as equivalent query

    consider the following: for l_child in (select * from dropdown where (p_category='Action' and category='Reason' and type=l_orig_contents) or (p_category='Action' and...
  20. goaway1234

    using WITH &lt;name&gt; AS (...) and ADO 2.8

    ...side2 as city, side3 as state, side4 as zip FROM dropdown WHERE category='Station') SELECT stations.region, stations.sector, job_categories.* FROM nwd.stations, nwd.job_categories WHERE job_categories.station (+) = stations.station ORDER BY stations.region, stations.sector This statement...

Part and Inventory Search

Back
Top