HTP | Hack The Printer | Hacking library

Include HTP.BR calls when necessary.

Answer your comment, if you want to do split by return carriage, one option might be regexp_substr and connect by

Example

The doc states that htp.p and htp.prn take only VARCHAR2 so you're limited by the max size of a varchar2 and if the clob length exceeds that it will throw an error. This is what you can do:

Loop through the clob in 4k chunks and output using htp.prn. Avoid using htp.p in a loop because that generates a newline characters which could mess up the output, for example if you're generating json. It's also good practice to let the browser know what he's getting by setting the mime header.

If you want all chars right of a given string try split

The Range and Content-Range HTTP headers are two completely different things. See Difference between Content-Range and Range headers?

Content-Range is for specifying the range of bytes that are in the body of the same message that contains the Content-Range header.

The Range header is for requesting a range of bytes from the server. The response message will indicate, via its own Content-Range, the actual range being sent in the response body.

So, that explains why you are getting a "missing Content-Range" error when using the TIdHTTP.Ranges property. That property is simply not intended for the purpose you are using it for.

As for using the TIdHTTP.Request.CustomHeaders property to send a Content-Range header, that is the correct way to go (technically, TIdEntityHeaderInfo has ContentRange... properties, but they are currently only used by TIdHTTP.Response, not by TIdHTTP.Request - that needs to be fixed).

The problem with your custom Content-Range header is that the server is simply rejecting it as bad. Which most likely means that the iSize value you are using doesn't actually match the number of bytes you are actually sending.

Try something more like this instead:

When you try to do such a thing in Tkinter it can be quite messy, I would suggest trying to move your menu() from lvls_menu into your main python script, and wrapping your whole main menu in another function so you can just reference the functions without having to go through messing with imports.

I have edited the provided code to this rough version that you can hopefully integrate into your program.

If you truly wanted to completely separate them, then your best bet would be to use pyinstaller to create exe's and use os.startfile() to start each executable that was made from your scripts, and just use exit() instead of .destroy() if you choose to go down that route since as I said importing modules for different menus can get extremely messy in Tkinter I would also suggest creating classes for menus and putting all the menu's respective functions inside of that class to somewhat organize it.

UPDATE

If this can help anyone, I've found this plug-in which gives you the possibility to refresh a PL/SQL Dynamic Content Region.

You can use APEX_JAVASCRIPT package, e.g. APEX_JAVASCRIPT.ADD_INLINE_CODE or APEX_JAVASCRIPT.ADD_ONLOAD_CODE procedures.

Something like this:

In that blog post, Jeff is putting that code in the source of the post handler, you're putting it in a pl/sql stored procedure. That does not compile because the bind variable :body_text does not exist in the scope of that procedure.

It should work if you put the following code in the source of the POST handler (not using the stored procedure):